ACC2002: Unexpected Error Occurs When Two Users Edit the Same Data in a Related Table (282382)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q282382
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you edit a record in a multi-user environment, you may receive the following error message when you attempt to commit your changes:
Write Conflict

This record has been changed by another user since you started editing it. If you save the record, you overwrite the changes the other user made.

By copying the changes to the clipboard, you are able to look at the values the other user entered, and then paste your changes back in if you decide to make changes.

Save Record
Copy to Clipboard
Drop Changes
If you click Save Record, you receive an error message similar to the following:
The record cannot be deleted or changed because table MyTable contains related records.

CAUSE

This behavior can occur if the record being edited has been changed and committed by another user since you began editing it.

RESOLUTION

To work around this issue, click OK to clear the error message, and then press ESC. The other user's changes to the record are now visible. Edit the record again and commit the changes. Note that no error message appears.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps To Reproduce the Problem

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. Open the sample database Northwind.mdb.
  2. Open the Categories table in Datasheet view.
  3. Type Case 1 at the end of the Description field for the first record, but do not move off the field or commit your changes.
  4. Start another instance of Microsoft Access and open the sample database Northwind.mdb.
  5. Open the Categories table in Datasheet view.
  6. Type Case 2 at the end of the Description field for the first record, and then press TAB twice to move off the record.
  7. Return to the first instance of Access and press TAB twice to move off the record.

    Note that you receive the first error message described in the "Symptoms" section.
  8. Click Save Record.

    Note that you receive the second error message described in the "Symptoms" section.
Modification Type:MajorLast Reviewed:11/6/2003
Keywords:kbbug kberrmsg kbnofix KB282382
©2003 Microsoft Corporation. All rights reserved.