I just created a form using FP2002.
I created this form using the FP wizard, and i chose the option to have the results put into an MS Access DB.
After I created the form (on my laptop) - I then transfered/copied the entire web to a directory on my IIS 6 server - just a subdirectory under my existing website. (C:\inetpub\wwwroot\myform\form.htm)
The problem I am experiencing is - the form appears to be working, it sends me to a confirmation page, but none of the data is put into the database that the FrontPage wizard created for me? The Confirmation page shows me that data that i just input for testing - but none of it is actually transferred to the mdb file.
Dont know if it is a server entension problem, but I believe that they are all installed?
Any help is really appreciated.
Most important is that the form should be form.asp not form.htm
Change it to form.asp
Then check the following:
Right click your form, select form properites, options, saved fields and make sure that the form fields are matching the database table fields. Then
1- Select Tools > Web Settings > Databases
2- Click on the database
3- Click verify
Try after that
If this did not work, they you will have to give permissions to the database. Give:
Everyone, anonymous internt account (write permissions)