This property indicates the type of locks placed on records during editing.
recordset.LockType
Returns one of the values described in the following table.
Constant |
Value |
Description |
adLockReadOnly | 1 | Default — You cannot add, delete, or change records. |
adLockOptimistic | 3 | You can add, delete, and change records. |
Use the LockType property to determine what type of locking the provider should use when opening a Recordset object or to return the type of locking in use on an open Recordset object. The LockType property is read/write when the Recordset is closed and read-only when it is open.
ADOCE does not support adLockPessimistic or adLockBatchOptimistic. Instead, ADOCE silently substitutes adLockOptimistic.