vishnu bobade

• Sep 8th, 2005

 

When you open a Recordset object, you can also specify the type of record locking you want to use by setting the lockedits argument of the OpenRecordset method to the appropriate constant. The following table lists the five constants you can use for the lockedits argument of the OpenRecordset method, and describes the ODBC cursor lock type to which they correspond.  
 

vidyajnath

 Profile Answers by vidyajnath 

• Apr 13th, 2010

 

LockUnspecified - Unspecified type of lock

LockReadOnly - Read-only records

LockPessimistic - Pessimistic locking, record by record. The provider lock records immediately after editing

LockOptimistic - Optimistic locking, record by record. The provider lock records only when calling update

LockBatchOptimistic - Optimistic batch updates. Required for batch update mode