Edit

LockTypeEnum enumeration (DAO)

  • Article

Applies to: Access 2013, Office 2013

Specifies the type of record locking used when opening a recordset.

Name

Value

Description

dbOptimistic

3

Optimistic concurrency based on record ID. Cursor compares record ID in old and new records to determine if changes have been made since the record was last accessed.

dbOptimisticBatch

5

Enables batch optimistic updates (ODBCDirect workspaces only).

dbOptimisticValue

1

Optimistic concurrency based on record values. Cursor compares data values in old and new records to determine if changes have been made since the record was last accessed (ODBCDirect workspaces only).

Note

ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

dbPessimistic

2

Pessimistic concurrency. Cursor uses the lowest level of locking sufficient to ensure that the record can be updated.