Microsoft KB Archive/275113

= ACC2002: &quot;Record Is Deleted&quot; Error After Synchronization =

Article ID: 275113

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q275113



Moderate: Requires basic macro, coding, and interoperability skills.

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

For a Microsoft Access 2000 version of this article, see 270116.



SYMPTOMS
When you try to save a record in a replica, you may receive the following error message:

Record is deleted.



CAUSE
This error occurs when you try to save a record and both of the following conditions are true:

A synchronization between replicas is occurring while a record is being edited.

-and-

The Default Record Locking option is set to No locks.



RESOLUTION
Make sure that each replica has saved all changes to records before synchronization begins and that no further edits are attempted until the synchronization is finished.



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 Behavior
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) On the Tools menu, click Options. Click the Advanced tab, and under Default record locking, click No Locks.
 * 3) On the Tools menu, point to Replication, and then click Create a Replica.
 * 4) In the Design Master, open the Customers table, and then modify the ContactName field for CustomerID ALFKI, changing the name Maria to Mary.
 * 5) Close the Customers table.
 * 6) Open a second instance of Access, and then open the replica that you created in step 3.
 * 7) Open the Customers table and edit the same ALFKI record, but do not commit the changes.
 * 8) Switch back to the first instance of Access.
 * 9) On the Tools menu, point to Replication, and then click Synchronize Now. Select the Directly with Replica option, select the replica that you created in step 3, and then click OK.
 * 10) Click Yes when you are prompted to close the database prior to synchronization, and then click OK if you are prompted that the synchronization was successful.
 * 11) If the synchronization was successful, switch back to the second instance of Access, and try to commit the record that you began editing earlier. Note that you receive the error message mentioned in the &quot;Symptoms&quot; section of this article.

Additional query words: prb admin replication replica set

Keywords: kberrmsg kbbug kbnofix KB275113

-

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

© Microsoft Corporation. All rights reserved.