ACC2000: Error Message: "Record Is Deleted" After Synchronization (270116)


The information in this article applies to:

  • Microsoft Access 2000
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 "Symptoms" section of this article.

REFERENCES

For additional information about other replication error messages, click the article number below to view the article in the Microsoft Knowledge Base:

264268 ACC2000: Replicas Encounter Record Editing Errors During Synchronization

Modification Type:MajorLast Reviewed:6/30/2004
Keywords:kbbug kberrmsg kbnofix KB270116
©2004 Microsoft Corporation. All rights reserved.