How does one lock a record in Access97 using ADO and the Jet Engine?
Printable View
How does one lock a record in Access97 using ADO and the Jet Engine?
Set the recordset to adLockPessimistic normally sorts out your problem
Hope this helps
Ian
I have tried this but it does not work. In case of a multiuser scenario the record being edited is not getting locked.