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.