Multiple concurrent inserts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi - I have developed an e-learning system that upto 20 users can take at any
one time. When the users are finished a process fires which calls an asp
page to insert the answers provided into an access db. If 2 users try and
submit at the same time only one set of results is entered and an
"Unspecified error" is given that refers to the line that opens the
connection to the db to the user whose results are not entered - any ideas /
help would be greatly appreciated as I MUST achieve multiple concurrent
inserts somehow.

Thanks in advance for any help.
 
Are you using a transaction to insert everything into the tables?
If not i would suggest to take a look into that.

You have to generate a transaction on your connection
Peform all the tasks as you normally would and then commit.
You also have to make sure that your transaction is commited in time (before
a connection timeout can be generated for another user).

- Raoul
 
Back
Top