Synchronize and resolve conflicts in a replica set (MDB)

Microsoft Office Access 2003

  1. Open the replica set member you want to synchronize.
  2. On the Tools menu, point to Replication, and then click Synchronize Now. (If a Synchronizer on the Internet manages any replica set member, you will see that the managed replica appears in the Directly with Replica drop-down list box as http://ServerName, where ServerName is the name of the Internet Server.
  3. Enter the path and file name of the replica set member you want to synchronize with the current database.
  4. If your database is the Design Master and you want to make the other replica the Design Master, select the Make 'Filename' the Design Master check box. (This option is unavailable if either of the replicas to be synchronized is a partial replica.)
  5. Click OK.
  6. When asked whether you want to close and reopen the database, click Yes. (If you click No, you might not see all of the changes.)

ShowSynchronize a replica by using Briefcase

  1. Double-click the My Briefcase icon, and then click the database file.
  2. On the Briefcase menu, click Update Selection.
  3. Click Update to have Briefcase exchange the updates.

Note  Briefcase does not support local or anonymous replicas.

ShowResolve synchronization conflicts between replica set members

  1. Start the Microsoft Replication Conflict Viewer by using one of the following steps:

    Open the database that you want to check for conflicts. If there are conflicts, you are asked whether you want to resolve them. Click Yes to proceed.

    On the Tools menu, point to Replication, and then click Resolve Conflicts.

  2. In the Conflict Viewer, select a table that has conflicts from the list, and click View.
  3. For each conflict shown in the Conflict Viewer, choose one of the following options.

    To keep the data in Replica 1, click Keep existing data.

    To modify the data in Replica 1 and copy it to Replica 2 on the next synchronization, click Keep revised data.

    To keep the data in Replica 2 and overwrite the data in Replica 1 on the next synchronization, click Overwrite with conflicting data.

    To modify the data in Replica 2 and overwrite the data in Replica 1 on the next synchronization, click Overwrite with revised data.

  4. Click Resolve.
  5. Repeat steps 3 and 4 as many times as necessary to resolve each conflict in the table.

Note  The record of conflicts can be lost if you delete or move a replica. Before deleting or moving a replica, check it for conflicts.

ShowUse a different program for resolving synchronization conflicts

  1. Open the Design Master for the replica set.
  2. On the File menu, click Database Properties.
  3. Click the Custom tab.
  4. In the Name box, type ReplicationConflictFunction.
  5. In the Type box, click Text.
  6. In the Value box, type the name of the custom function followed by ( ). For example, if the name of the custom function is MyResolver, type MyResolver( ).