Microsoft KB Archive/270116

= ACC2000: Error Message: &quot;Record Is Deleted&quot; After Synchronization =

Article ID: 270116

Article Last Modified on 6/30/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q270116



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

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

For a Microsoft Access 2002 version of this article, see 275113.



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

Record is deleted.



CAUSE
This error can occur when you save a record when 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.



MORE INFORMATION
To set a locking scheme, click Options on the Tools menu, click the Advanced tab, and then set the locking scheme to what you want it to be.

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 then under Default record locking, click No Locks.
 * 3) Convert the Northwind database to a Design Master, and then create a replica.
 * 4) In the Design Master, open the Customers table, and then modify the ContactName field for CustomerID ALFKI. For example, change the name Maria to Mary.
 * 5) Close the Customers table, open a second instance of Access, and in this second instance, open the replica that you created in step 3.
 * 6) Open the Customers table, begin editing the same ALFKI record, but do not commit the changes.
 * 7) Switch back to the first instance of Access.
 * 8) 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.
 * 9) Click Yes when you are prompted to close the database prior to synchronization, and click OK if you are prompted that the synchronization was successful.
 * 10) 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 that is mentioned in the &quot;Symptoms&quot; section of this article.

