Concurrent Users w/Access&ADO 1

[chadrj]

I have an application that uses ADO to access an Access 97 DB. Everything works fine with one user, but in testing with multiple users I get various errors. I am having a hard time finding any information on how to handle multiple users with different recordsets from the same table.

The problem occurs when I carry out the following process on 2 separate machines

Machine 1 - Add new record
Machine 2 - add new record

Machine 1 - modify record previousy added by Machine 1 * try to update ***Here is where the error occurs. The record does not update because it has been deleted from the database. I must repair the database each time this happens.

I can provide more information if needed, but want to avoid composing a novel.

Thanks!

 

[chadrj]

Great! Thanks for your help. I will migrate to this new method, and have more confidence that my db will be safe if I'm not here for a day.