I have an Access 2010 database. I have two forms, FormA and FormB in the database which each point to the same table.
Scenario... UserA is editing FormA. UserB opens FormB, makes changes and closes it. UserB opens same FormB again and confirms changes were made. UserA finishes making his changes and when he exits the form gets a Write Conflict error which states "This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Copying the changes...". The user has the option to Save Record, Copy to Clipboard, or Drop Changes.
If UserA chooses Save Record, then UserB's changes revert so they are lost.
Under File, Options, Client Settings, Advanced, the Default record locking is set to "No locks". This is what I want.
Here is the problem. I cannot force UserA to Drop Changes so UserB's changes aren't lost. Therefore, I need to write code so whoever gets the Write Conflict popup will get a message from me with instructions on how to handle the write conflict. I just can't seem to capture the Write Conflict.
Can anyone help me with this?
Thanks in advance!