ADO: ActiveX Data Objects

Name

LockTypeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

The LockTypeEnum enumeration specifies the lock to use on records while they are being edited.

Table E-29. The LockTypeEnum Enumeration

Enumeration (ADO/WFC)	Value	Description
adLockBatchOptimistic (BATCHOPTIMISTIC)	4	Required for batch update mode. Should be used only by a keyset or static cursor.
adLockOptimistic (OPTIMISTIC)	3	Indicates that the record is locked once the Update method has been called.
adLockPessimistic (PESSIMISTIC)	2	Indicates that the record is locked once editing has begun.
adLockReadOnly (READONLY)	1	Default. Indicates that the data is read-only.

ADO/WFC

The LockTypeEnum enumeration is part of the com.ms.wfc.data package, and the constant values are preceded with AdoEnums.IsolationLevel.

See Also

Connection.WillExecute Event, Recordset.Clone Method, Recordset.LockType Property, Recordset.Open Method