I have a small database which will only be shared by a couple of users. It will be a very rare case when two users will be editing the same record at the same time. However, I tested the situation anyway. The default access box has an option to save user one changes and disregard user 2 changes.
Access corrupts the current record when this option is selected. I have have to re-import the item from a backup. I have implemted an on error handler to trap for this situation and trained the users to always select the drop change option.
I am curious if anyone else has had this error occured. All the access books I have state Access 2000 should just disregard user 2 and go with the user one edits and not corrupt the record.
Thanks!
Access corrupts the current record when this option is selected. I have have to re-import the item from a backup. I have implemted an on error handler to trap for this situation and trained the users to always select the drop change option.
I am curious if anyone else has had this error occured. All the access books I have state Access 2000 should just disregard user 2 and go with the user one edits and not corrupt the record.
Thanks!