ACC1x: Referential Integrity Error Message with Shared Databases

Last reviewed: May 14, 1997
Article ID: Q95004
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1

SYMPTOMS

When you share databases in Microsoft Access and try to update a record that another user has already updated, your update fails and Microsoft Access generates the following message:

   Data has changed; Operation stopped.

When you choose OK, Microsoft Access generates 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.

You can choose one of three option buttons:
  • Save Record
  • Copy To Clipboard
  • Drop Changes

Copying your changes to the Clipboard allows you to look at the values the other user has entered and paste your own changes back into the table. However, when you choose Paste, your attempt fails and Microsoft Access generates the following referential integrity error message:

   Can't delete or change record. Since related records exist in table
   "<Table Name>", referential integrity rules would be violated.

CAUSE

Your table is on the "one" side of a one-to-many relationship and the Enforce Referential Integrity check box is selected. These symptoms occur regardless of the field being edited.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access versions 1.0 and 1.1. This problem no longer occurs in Microsoft Access version 2.0.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open two instances of Microsoft Access. In each instance, open the sample database NWIND.MDB. Make sure that the database is not opened with exclusive access.

  2. In each instance, open the Categories table.

  3. In the first instance, change the Category Name field in the first record. Do not commit the change.

  4. In the second instance, change the Category Name field in the first record. Commit the change by moving the indicator to a field in another record.

  5. Restore the first instance and try to commit the change. Microsoft Access generates the first of the two error messages listed above. When the second error message appears, choose Copy To Clipboard.

  6. Select the first record from the first instance of Microsoft Access. From the Edit menu, choose Paste.

  7. Try to close the table. Microsoft Access generates the referential integrity error message listed above.


Additional query words: multiuser
Keywords : kberrmsg kbusage RltRef
Version : 1.0 1.1
Platform : WINDOWS
Hardware : X86
Issue type : kbbug
Resolution Type : kbfix


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.