DEALING WITH REPLICATION CONFLICTS

Replicated databases introduce a new problem: What happens when users at different replicas simultaneously make incompatible modifications to the data or design? In Access 2000, the events that cause synchronization conflicts and errors are both viewed simply as synchronization conflicts. A single mechanism is used to record and resolve them, making resolution of such problems easier. When a conflict occurs, a resolution algorithm determines a winner and a loser. This release of replication introduces an algorithm whereby replicas in a replica set are assigned priorities, and the highest priority replica wins in a synchronization conflict. Where priorities are equal, the replica with the lowest replica ID wins. ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.