See Also
Applies To
Table object, Dynaset object
Description
Determines which locking condition is in effect during editing. Not available at design time; read/write at run time.
Syntax
recordset.LockEdits [ = { True | False}]
Setting
The LockEdits property settings are:
Setting Description
True (Default) Pessimistic locking is in effect for all editing. The page containing the record you are editing is locked while in edit mode (EditMode property setting = 1).
False Optimistic locking is in effect for all editing. The page containing the record is locked only while you actually update the record with the Update method.
Remarks
If a page is locked (LockEdits is True), then no other user can edit records on the same page. If you set LockEdits to True and another user already has the page locked, an error occurs when you use the Edit method.
If you set LockEdits to False and later use Update while the page is locked by another user, an error occurs.