Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 883870 - Last Review: January 10, 2007 - Revision: 1.3
Microsoft Replication Conflict Viewer displays “<No conflict tables>†even when synchronization conflicts exist among the replicas in Microsoft Access
This article applies only to a Microsoft Access database (.mdb).
Advanced: Requires expert coding, interoperability, and multiuser skills.
When you try to synchronize the members of a replica set in Microsoft Access, you may notice that synchronization conflicts may occur. You may receive the following error message:
This member of the replica set has conflicts from synchronizing changes with other members.
Do you want to resolve these conflicts now?
However, when you click
Yes to resolve synchronization conflicts by using Microsoft Replication Conflict Viewer, you may notice that Replication Conflict Viewer does not display the list of tables that are involved in synchronization conflicts. The
Tables with conflicts list in the
Microsoft Replication Conflict Viewer dialog box displays
<No conflict tables>.
Therefore, you cannot resolve synchronization conflicts in the replica of your Access database.
One of the replicas in your replica set that you are trying to synchronize is corrupted.
The MSysConflicts system table stores information that is related to each conflict in your replica set. Notice that the MSysConflicts system table displays the following message to explain why a synchronization conflict has occurred. The following message is displayed in the
Reason column of the MSysConflicts system table:
Recovered replicable data. This row was recovered from a corrupted replicable database. Verify that the record contents are correct and then reinsert the record, or delete the conflict record.
To work around this problem, you must resolve synchronization conflicts manually. To do this, follow these steps:
- Start Access, and then open your replicated Access database.
- In the Database window, click Options on the Tools menu, and then click the View tab.
- In the Show section, click to select the Hidden objects check box, click Apply, and then click OK.
- In the Database window, click Tables in the Objects section.
- In the right pane, examine all the tables to verify whether there are additional tables that are named <Table Name>_Conflict.
Note The placeholder that is named <Table Name> is a placeholder for the name of the table that is involved in the synchronization conflict.
For example, if there is a
conflict in the Customers table, an additional table that is named the Customers_Conflict table is created during the synchronization. - Write down the details of all the records in the tables that are identified in step 5, and then delete the tables.
Notice after you delete the tables with the _Conflict suffix, you do not receive the synchronization conflict error message that is mentioned in the "Symptoms" section. - Resolve the conflicts manually by comparing the records in your table and the records in the conflict table that correspond to your table. Then, correct the conflicting records in your table.
For additional information about database replication in Microsoft Jet 4.0, visit the following Microsoft Developer Network (MSDN) Web site:
APPLIES TO
- Microsoft Office Access 2003
- Microsoft Access 2002 Standard Edition
- Microsoft Access 2000 Standard Edition
| kbreplication kbdatabase kberrmsg kbtshoot kbprb KB883870 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate