Optimistic Record locking (networked Database)
Can someone help me....
In Access if you set up:
No Locks - Microsoft Access does not lock the record you're editing. When
you try to save changes to a record that another person has also changed,
Microsoft Access displays a message giving you the options of overwriting
the other user's changes to the record, copying your version of the record
to the Clipboard, or discarding your changes.
QUESTION:
How can I get VB to trapped the same message (using an Access Database with
"no locks") ? In other words, how does VB know that another user is trying
to edit the record also ? I am accessing the record through program code
(rather then the Data Control) and changes get overwritten without warning.
TIA,
Brenda