ACC2002: Data in Replica Sets Does Not Match as Expected After Synchronization (282316)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q282316
Advanced: Requires expert coding, interoperability, and multiuser skills.

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

SYMPTOMS

After you have synchronized one member of a replica set with another, some of the data in the two databases may not match as expected.

CAUSE

This behavior can occur if the data in a field is being edited while changes to the same field in the same record are being communicated by synchronization.

RESOLUTION

To prevent this issue from occurring, make sure that no one is editing records in a table when you run synchronization.

Another way to prevent this behavior is to upsize the database from a Microsoft Access database (.mdb) to Microsoft SQL Server or a Microsoft Access project (.adp), and then use SQL Server's replication functionality.

For more information about upsizing your database, click Microsoft Access Help on the Help menu, type upsizing in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

For additional information about upsizing your database, click the article number below to view the article in the Microsoft Knowledge Base:

294407 ACC2002: "Access 2002 Upsizing Tools" White Paper Available in Download Center

For additional information about replication in Microsoft SQL Server 2000, browse to the following Microsoft Web site:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

To resolve this issue when it occurs, make note of any write conflicts you get when synchronizing. After synchronization is complete, check the records that had the write conflict. If the data is not correct, modify the record, and then synchronize again. This will send the changes and cause a conflict that will have to be resolved.

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

  1. Start Access, and then click Blank Database on the New File task pane.
  2. In the File name box, type Design Master, and then click Create.
  3. On the Tools menu, click Options, and then click to clear the Open databases using record-level locking check box on the Advanced tab.
  4. Quit and reopen Access, and then reopen the Design Master database.
  5. Double-click Create table by entering data.
  6. In the first record, type Field One under Field1, and then click Save on the toolbar.
  7. Click OK in the Save As dialog box, click Yes to have Access create a primary key, and then close the table.
  8. On the Tools menu, point to Replication, click Create Replica, and then click Yes when you see the "This database must be closed before you can create a replica" message.
  9. Click No to skip the creation of a backup copy of the database, click OK to create a replica named "Replica of Design Master," and then click OK.
  10. In the Design Master Database window, double-click Table1, change "Field One" to "Field 1," and then close the table.
  11. Start a second instance of Access, and then open the database Replica of Design Master.
  12. Double-click Table1, change "Field One" to "First Field," but do not save the record and do not close the table.
  13. On the taskbar, click Design Master: Design Master.
  14. On the Tools menu, point to Replication, and then click Synchronize Now.
  15. In the Synchronize Database 'Design Master' dialog box, click OK, and then click Yes to close the database before synchronization.
  16. Click OK when synchronization has been completed successfully.
  17. On the taskbar, click Table1: Table (Replicated).
  18. Close the table, and then click Save Record when you see the "Write Conflict" message.
  19. On the taskbar, click Design Master: Design Master.
  20. On the Tools menu, point to Replication, and then click Synchronize Now.
  21. In the Synchronize Database 'Design Master' dialog box, click OK, and then click Yes to close the database before synchronization.
  22. Click OK when synchronization has been completed successfully.
  23. Compare the data in Field1 in Design Master and Replica of Design Master.

    Notice that the records have not been synchronized.

REFERENCES

For more information about replicated databases, click Microsoft Access Help on the Help menu, type replication in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

For more information about record locking, click Microsoft Access Help on the Help menu, type record locking in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug KB282316
©2003 Microsoft Corporation. All rights reserved.