In Microsoft Access using mdb file as data store when the form property: "Record Locks" is set to "Edited Record" the form uses pessimistic locking. If one user is editing a particular record the other user can view the previously saved record but cannot edit it. All the fields are simply locked. Also the record selected shows "editing in progress" icon.

In VB with ADODC control I cannot reproduce/duplicate the above behavior no matter what data source I am using even with cursor location set to server and locking set to adLockPessimistic. Both users are able to edit the text in their text boxes but only the first updater of record gets to update while the second receives error message that record has been changed! Is there any way I can duplicate the way MS Access does as above. It seems that editing a bound textbox does not trigger a locking of that record or another users textbox.