O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required