Share via


LockTypeEnum Enumeration (DAO)

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).

NoteNote
ODBCDirect workspaces are not supported in Microsoft Access 2010. 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.