Resolving Conflicts by Using Microsoft Access

If you handle replication through the Microsoft Access user interface, Microsoft Access automatically notifies you of a synchronization conflict each time you open a database that contains conflicts. Microsoft Access ships with a Conflict Resolver to assist you in displaying a list of all tables that have synchronization conflicts and choosing whether to apply the data from the conflict table. You run the Conflict Resolver by clicking Yes when asked if you want assistance with resolving the conflicts. You can also launch the Conflict Resolver at any time by pointing to Replication on the Microsoft Access Tools menu, and then clicking Resolve Conflicts.

You can replace the Conflict Resolver with a custom function for reviewing and processing the records in a conflict table. If you want to use a custom function instead of the Conflict Resolver, create the ReplicationConflictFunction property and set its value to the name of the custom function. The custom function must be stored in a module in the Design Master (not as a separate dynamic-link library), and the module must be replicable.

Û To replace the Microsoft Access Conflict Resolver

On the Microsoft Access File menu, click Open Database.
Select (highlight) the Design Master that you want to have use the custom conflict-resolution function and click Open.
On the File menu, click Database Properties.
Click the Custom tab.
In the Name box, type ReplicationConflictFunction (do not put spaces between the words).
In the Value box, enter the name of the custom function followed by ( ).
Click OK to close the dialog box.

If you want to return to using the default Conflict Resolver after using a custom function, set the ReplicationConflictFunction property’s value to " " (an empty string). If you want to disable the default Conflict Resolver, but you don’t want to implement a custom one, you can set the ReplicationConflictFunction property to call a function that doesn’t do anything.