Confirmation form appears, no info is written to the database ,id field increment

[grizzle56]

Occasionally when someone submits a form they get the confirmation
page but the data they entered is not stored in the database.

The next data that is successfully stored in the database has a ID
field incremented as though the previous data had in fact stored.

The frustrating thing is that it is not consistant! Whenever I or my
provider try to submit a form it works just fine yet I can see where
the primary key ID field has incremented by 3 or 4 with no data and
people tell me they got the confirmation page!

It was set up using FP 2003, MS Access 2003 and resides on MS Server
2003 with our provider.

 

[David Berry]

How are you writing data to the database? Are you using your own ASP
Script, the FrontPage database wizard etc? What you need to do is to have a
check in your script to verify that the database write occurred before they
are sent to the confirmation page. If not then you'd display an error
message.

 

[grizzle56]

I am using the FrontPage Database Wizard. The strange thing is that
the the ID auto increment field increments even though no data is
stored.

 

[Kathleen Anderson [MVP - FrontPage]]

In FrontPage 2003 and in FrontPage 2002, a confirmation form appears, but no
information is written to the database

http://support.microsoft.com/default.aspx/kb/314440/en-us?spid=2514&sid=391

HTH,

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others