Lock « Access « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Access
  3. Lock
1.Use Row Level Locking
2.Default Record Locking
3.Set and get the lock type
4.use optimictic lock to open recordset
5.Configuration of LockType as a Property of the Recordset Object
6.Set Lock Type to adLockOptimistic