Syntax

put rst.LockType
rst.LockType=rst.adLockReadOnly
rst.LockType=rst.adLockPessimistic
rst.LockType=rst.adLockOptimistic
rst.LockType=rst.adLockBatchOptimistic

Sets or gets

Integer
value that determines what type of locking (concurrency) the provider should use when opening the Recordset. The default value is adLockReadOnly. It can be one of the LockTypeEnum values.

Description

Sets or gets the LockType property of the wrapped ADODB.Recordset object. Set the LockType property before opening a Recordset to specify what type of locking the provider should use when opening it. Read the property 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.