Indicates the type of locks placed on records during editing.
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. |
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.