Frontpage Form Intermittantly Not Updating Access Database

[pudabean]

I have a Frontpage Form which 99% of the time successfully adds a
record to my access database before continuing to the confirmation
page, which I have set up as a PayPal payment page. This is for a
tournament registration. Of the 138 online registrations so far, 7 of
the registrations have not updated the database, yet they have
continued to the PayPal payment screen and made the payment.

I've used this same system other time on another website without a
problem. I can't figure out why this only occurs once in a while,
though I do notice that all 7 of these people live in the same
city/area. I have to fix this pronto. Any suggestions?

 

[Stefan B Rusynko]

Too vague for anyone to guess what may or may no be working
- could be any of many errors (most often data related) causing the failure to write to DB

Update the DB from what - hand coded script or DBRW?
If hand coded add a loop to read the new record after the write before you send them to confirmation page

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I have a Frontpage Form which 99% of the time successfully adds a
| record to my access database before continuing to the confirmation
| page, which I have set up as a PayPal payment page. This is for a
| tournament registration. Of the 138 online registrations so far, 7 of
| the registrations have not updated the database, yet they have
| continued to the PayPal payment screen and made the payment.
|
| I've used this same system other time on another website without a
| problem. I can't figure out why this only occurs once in a while,
| though I do notice that all 7 of these people live in the same
| city/area. I have to fix this pronto. Any suggestions?
|

 

[Thomas A. Rowe]

Are you relying on the users going/returning to/from PayPal before the data is written to the
database? Is so then the users may not be returning from PayPal, and you have no control over this.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================