Use Row Level Locking : Lock « Access « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Access
  3. Lock

Use Row Level Locking

 

Sub SetGranularity()
    Application.SetOption "Use Row Level Locking", True
End Sub








Related examples in the same category

1.Default Record Locking
2.Set and get the lock type
3.use optimictic lock to open recordset
4.Configuration of LockType as a Property of the Recordset Object
5.Set Lock Type to adLockOptimistic