LockType - property of the AdoRecordset object
Returns or sets a value that specifies the type of locking when editing a record in the AdoRecordset
The property returns or sets a LockTypeEnum
value that specifies the type of locking when editing a record in the AdoRecordset
object. This property is read/write on a closed AdoRecordset
object and read only on an open AdoRecordset
Unspecified type of lock. Clones inherits lock type from the original AdoRecordset
1 - adLockReadOnly (Default) Read-only records.
2 - adLockPessimistic Pessimistic locking, record by record. The provider lock records immediately after editing.
3 - adLockOptimistic Optimistic locking, record by record. The provider lock records only when calling update.
4 - adLockBatchOptimistic Optimistic batch updates. Required for batch update mode.
Property access for read and write.
oRs.LockType = 4;