According to the MSDN:-

Using pessimistic locking, the engine locks the page that contains the record being edited as soon as the Edit method is issued, and doesn’t release the lock until the changes to the record are explicitly committed or canceled. Pessimistic locking is the default locking mode for recordsets.


Ok, so I can release a lock by using RecordSet.Update but how can I release the lock without performing an update?


Dazed And Confused

recordset.CancelUpdate