Microsoft KB Archive/282382

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

Article ID: 282382

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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  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.



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 &quot;Symptoms&quot; section.
 * 1) Click Save Record.

Note that you receive the second error message described in the &quot;Symptoms&quot; section.

Additional query words: pra

Keywords: kberrmsg kbbug kbnofix KB282382

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.