Call this member function to determine the type of locking in effect for the recordset.
BOOL GetLockingMode( );
Nonzero if the type of locking is pessimistic, otherwise 0 for optimistic record locking.
When pessimistic locking is in effect, the data page containing the record you are editing is locked as soon as you call the Edit member function. The page is unlocked when you call the Update or Close member function or any of the Move or Find operations.
When optimistic locking is in effect, the data page containing the record is locked only while the record is being updated with the Update member function.
When working with ODBC data sources, the locking mode is always optimistic.
For related information, see the topics "LockEdits Property" and "Locking Behavior in Multiuser Applications" in DAO Help.