LockType

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.