Save Form Data to Access DB

[MeeMee]

Hi

I have a problem with saving form data to a MS Access database. I am using Windows XP, FrontPage 2003, Access 2003, IIS 5.1 and FrontPage Server Extensions.

I have followed several tutorials I found online, created a simple form and changed its properties so that when the data is submitted it is saved into the database. When I click on the submit button , I get a confirmation page but nothing is written in the database. I have tried this with both automatically generated FrontPage database and with an existing database but nothing is saved.

I am doing all of this locally by publishing my website to the "wwwroot" folder. I have searched google but got nothing.

I am a beginner in IIS and FP extensions, is there specific settings that I have to use after installing them ??

Please Help

Thanks in Advance ..

[idsanjeev]

Hi MeeMee
aren't getting any error ?
Can you attached your code
thanks

[MeeMee]

Hi MeeMee
aren't getting any error ?
Can you attached your code
thanks

Hi,

No I get no error, anyway it finally worked after I changed the permission to the wwwroot folder by going to Properties > Security.

I have another question, the intranet website has not asp code at all, it is all html, so it is not in the wwwroot folder. I am not that experienced with servers, now I know that IIS and FP extensions must be installed on the server so that the form works , just like I did locally. I guess that on the server I should publish the forms to the wwwroot folder again, however will I face problems if I put a hyperlink to the form (which is the wwwroot folder) on the homepage of the intarnet site ?? and what should the link be ?? Locally I access the form using localhost\form. asp

sorry for the long story :)

[DrBunchman]

Hi MeeMee,

If the intranet is located on the same server as the website then the link should be:

 
<a href="http://localhost/form.asp">Hello World!</a>

If the intranet is loocated on a different server then it will be:

 
<a href="http://server/form.asp">Hello World!</a>

Where server is the machine name or IP address where your website is located. You may experience problems depending on the security you have set on your website but give it a go and see how you get on.

Do you have any experience using the IIS console to configure your deployed websites?

Dr B

[MeeMee]

Thanks alot for your help, I will give it a try ..

I installed it IIS locally so I can work with forms, and till now I didn't need to configure anything in its console, I am trying to read as much as I can about the deployment process, I found this

http://support.microsoft.com/kb/299868

It seems simple, but I am not sure if this is all that I need .. I'd appreciate your advice.

Thanks alot

[DrBunchman]

That seems like a pretty good guide to get you started. For the time being you can deploy your website in the wwwroot folder and access it through the default website as it describes.

I suggest you go ahead and follow it and come back to us if you have any questions or come across any problems.

Good luck,

Dr B