There is a very remote possibility that both update requests will hit the Access DB at almost exactly the same millisecond in time
(I have never seen it happen if you always close the connection right after the update )
- when that happens one will go thru (because it was a microsecond before the other) and the other will probably get an error or
server script time out and have to resubmit
Only way to really test for it is w/ a very complex loading testing system
If you are that concerned about it, either upgrade to SQL or add error checking routines to your writes (read after write to verify
& redirect on error)
| if one user fill out the form twice, I'll have two same records but different
| time stamps. ..
| I want to make..two users can fill out the form at the same time (same time
| stamp) so I can have two records-two different user's name with same time
| stamps.
|
| "Kevin Spencer" wrote:
|
| > What happens when you fill out the form (one user) twice?
| >
| > --
| > HTH,
| >
| > Kevin Spencer
| > Microsoft MVP
| > ..Net Developer
| > The sun never sets on
| > the Kingdom of Heaven
| >
| > | > > If there are two users sign the form, (users typed name and click submit
| > > button),
| > > only one user's form go thru DB. When I checked the table (Access 2003),
| > > only one user's info is in it.
| > > Is there anyway I can get two users' info eventhough they have same 'time
| > > stamp'?
| > > "Kevin Spencer" wrote:
| > >
| > >> Nothing in a computer actually happens "at the same time." I'm not sure
| > >> what
| > >> the problem is, but you should not have such a problem.
| > >>
| > >> --
| > >> HTH,
| > >>
| > >> Kevin Spencer
| > >> Microsoft MVP
| > >> ..Net Developer
| > >> The sun never sets on
| > >> the Kingdom of Heaven
| > >>
| > >> | > >> > the question is.. I have access dabase connected to web page.
| > >> > Many users submit the form and info goes to databse. My problem is only
| > >> > one
| > >> > user can submit form. If more than one user submit form at the same
| > >> > time,
| > >> > only one user's form go thru DB.
| > >> > What method do I have to use?
| > >>
| > >>
| > >>
| >
| >
| >
