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

  • Thread starter Thread starter grizzle56
  • Start date Start date
G

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.
 
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.
 
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.
 
Back
Top