Multiuser database access

[msdnexpert]

I am using Access97,VB6 and ADO 2.1.
When two people are trying to edit the data in the same table simultaneously I get an error message. The recordset uses pessimistic locking. Also the same code works fine on SQL Server and Oracle.
Any suggestions on how to implement record locking in Access or some other workaround.

Shortly before I said goodbye to access and switched to
sql7. I was writing strings to a text file on my server something to the effect of " connected = yes" when I opened my DB connection and changed it to " Connected = no"
when I closed My DB connection. Then I just Checked the
text file before performing DB actions. If I got an error because the file was locked or The string said "connected = yes" then I looped Until both conditions were false.
access blows!(not in a good way)