When you share a database in Microsoft Access and try to update a record
that another user has already updated, your update is not successful, and
you receive the following error message:
Data has changed; Operation stopped.
After you click the OK button, you receive the following write-conflict
error message:
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 to the clipboard will let you look at
the values the other user entered, and then paste your changes
back in if you decide to make changes.
You can choose one of three option buttons:
Save Record
Copy To Clipboard
Drop Changes
If you choose Save Record, Microsoft Access does not update the record, and
you receive the following referential integrity error message:
The Record cannot be deleted or changed because table '<Table Name>'
includes related records.
CAUSE
=====
You have a one-to-many relationship between your tables where the Enforce
Referential Integrity option is turned on and the Cascade Update Related
Fields option is turned off.
RESOLUTION
==========
To work around this problem, modify the one-to-many relationship to select
the Cascade Update Related Fields option.
