AUTOMATING STAR AND HUB SYNCHRONIZATION
A simple example demonstrates how you can code synchronizations between replicas in a star and hub topology. It's assumed that you already have code that writes the path to any new replica created in a table called Replicas, and you define which replica is the hub.
The table Replicas has two fields:
ReplicaPath. A string pathname to each replica in the replica set.
Hub. A Boolean: “Yes” if it's the hub; otherwise, “No.”
The code simply creates a recordset from the Replicas table, and then loops through the records. If the current record doesn't point to the hub, synchronize by using ReplicaPath.
The code in Listing 23.5 is behind a button named cmdSyncAllReplicas on the Synchronize Star & Hub Topology form. ...
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.
