Submitting Form Data to an Access Database

[Janie]

Hello-
I have been researching this problem for days now - trying out a number of
options I have located on support sites - to no avail. I am hoping one of
you has a suggestion.....

My problem is that the webpage form is published, the form can be filled out
live, a confirmation page is sent....but no data is sent to the database. No
error message is displayed at any time.

I am very new to Frontpage so I was hoping it was something I overlooked
however one of our IT guys has checked it out too and cannot come up with
anything.

We are running an IIS server - Windows 2000 Professional - Frontpage 2003.

Thank you so much in advance!

 

[Kathleen Anderson [MVP - FrontPage]]

Make sure you're not using any reserved words as field names:
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Janie]

Thanks for replying - I do not believe I am but I will check to confirm on
this tomorrow and post back - Thanks again!

 

[Janie]

Kathleen-
I checked the field names in Access and I did not find any that are reserved
names. However, something interesting happened. I deleted the current
database & connection and before I had Frontpage create a new
database/connection I opened the live form and submitted information. I
received a confirmation page saying the info had been submitted. But there
was no database, I had saved that change before I entered the live form.

Any suggestions? Thank you very much!

 

[Tom Miller]

However, something interesting happened. I deleted the current

database & connection and before I had Frontpage create a new
database/connection I opened the live form and submitted information. I
received a confirmation page saying the info had been submitted. But
there
was no database, I had saved that change before I entered the live form.

Its beginning to sound like your going to need to "post the code" before
anyone can troubleshoot any further. Don't forget to XXX out any
passwords...

Thanks,
Tom

 

[Kathleen Anderson [MVP - FrontPage]]

In the "Save to Database" form there really isn't any code to show. It's a
matter of checking to make sure that all the form fields are mapped
correctly to fields in the database. I would recommend creating an empty
database using the field names that the form fields are mapped to, and
import the database into the web site, and try again.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/