I have a database where I retrieve a record using ADO, then populate controls or bind the record to a form. The user can change data without affecting the actual table until they decide to save their changes. A timestamp is included in tables that will be accessed regularly so we can avoid overwriting data that was updated by another user.
I am trying to bypass the standard warning messages that Access gives you when someone else has already updated the record. Most importantly I am trying to recognize the record has been updated by another user and then ask the user to cancel, keep their data and highlight data changed by the other user, or discard the data and load the new data. I trapped the error on update as error -2147217864, however even if I try to bypass the error, Access takes over and asks to save the data to clipboard. Any idea how I can bypass Access for both actions, the error response and the clipboard form?
I am trying to bypass the standard warning messages that Access gives you when someone else has already updated the record. Most importantly I am trying to recognize the record has been updated by another user and then ask the user to cancel, keep their data and highlight data changed by the other user, or discard the data and load the new data. I trapped the error on update as error -2147217864, however even if I try to bypass the error, Access takes over and asks to save the data to clipboard. Any idea how I can bypass Access for both actions, the error response and the clipboard form?
