Record locking using ADO with Access Database

[PaulBarter]

How do you use record locking with ADO? It seems to lock the whole file, regardless of the record set I read. In Access itself you can specify row locking so obviously it can be done, but what do you need to do in VB.

 

[JimHorton]

When you open the recordset, you use an option, ie, from the Help file for ADO Recordset:<br>rst.Open Source, ActiveConnection, CursorType, LockType, Options

 

[PaulBarter]

Thanks for your comments.<br><br>I have tried setting cursor location = adUseServer and cursortype = adOpenKeyset and locktype = adLockPessimistic but it still locks the whole Access table.<br><br>Is there something else I should try?

 

[DannyB]

Try the <br><br>&nbsp;&nbsp;location = adUseClient <br><br> <p> <br><a href=mailto: > </a><br><a href= > </a><br>