Subject: Pessimistic locking
Posted By: Skittle Post Date: 11/17/2003 7:04:26 AM
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
Reply By: pgtips Reply Date: 11/17/2003 7:43:13 AM
recordset.CancelUpdate

Go to topic 6504

Return to index page 1004
Return to index page 1003
Return to index page 1002
Return to index page 1001
Return to index page 1000
Return to index page 999
Return to index page 998
Return to index page 997
Return to index page 996
Return to index page 995