Is it possible to lock a single record using ADO 2.0 in MSAccess 2000 from VB 6.0. I have got a situtation where I have to lock a single record exclusively for a very brief period.
If not then how can I open the table in exclusive mode ? I have tried various combination of Lock and cursor type but none seem to work.
Thanks in advance