LockType Property

Indicates the type of locks placed on records during editing.

Settings and Return Values

Sets or returns one of the following LockTypeEnum values:

Constant	Value	Description
adLockReadOnly	1	Read-only ¾ you cannot alter the data.
adLockPessimistic	2	Pessimistic locking, record by record ¾ the provider does what is necessary to ensure successful editing of the records, usually by locking records at the data source immediately upon editing.
adLockOptimistic	3	Optimistic locking, record by record ¾ the provider uses optimistic locking, locking records only when you call the Update method.
adLockBatchOptimistic	4	Optimistic batch updates ¾ required for batch update mode as opposed to immediate update mode.

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.

Providers may not support all lock types. If a provider cannot support the requested LockType setting, it will substitute another type of locking. To determine the actual locking functionality available in a Recordset object, use the Supports method.

Note To use batch updating (adLockBatchOptimistic), you should select either a keyset or static cursor.

Applies To

Recordset

See Also

CancelBatch, UpdateBatch