This property indicates the type of locks placed on records during editing.
Syntax
recordset.LockType
Return Values
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. |
Remarks
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.