Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Access
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
A comparison of global, local, and anonymous replicas (MDB)
 

Note  The information in this topic applies only to a Microsoft Access database (.mdb).

Some of the content in this topic may not be applicable to some languages.

There are three types of replica (replica: A copy of a database that is a member of a replica set and can be synchronized with other replicas in the set. Changes to the data in a replicated table in one replica are sent and applied to the other replicas.) visibility (visibility: A property of a replica that indicates which members of the replica set it can synchronize with and which conflict resolution rules apply. Replicas fall into three visibility types: global, local, and anonymous.) that are available in Microsoft Access: global (global replica: A replica in which changes are fully tracked and can be exchanged with any global replica in the set. A global replica can also exchange changes with any local or anonymous replicas for which it becomes the hub.), local (local replica: A replica that exchanges data with its hub or a global replica but not with other replicas in the replica set.), and anonymous (anonymous replica: In an Access database, a special type of replica in which you don't keep track of individual users. The anonymous replica is particularly useful in an Internet situation where you expect many users to download replicas.). A replica's visibility type determines several issues for the replica. For instance, a replica's visibility determines what type of replicas it can create from itself, whether it can act as the Design Master (Design Master: The only member of the replica set in which you can make changes to the database structure that can be propagated to other replicas.) in the replica set (replica set: The Design Master and all replicas that share the same database design and unique replica set identifier.), and how it handles conflicts during synchronization (synchronization: The process of updating two members of a replica set by exchanging all updated records and objects in each member. Two replica set members are synchronized when the changes in each have been applied to the other.). The visibility also determines which replicas that replica can synchronize with.

ShowRecommended replica use

Global Use to serve as a hub (hub: A global replica to which all replicas in the replica set synchronize their changes. The hub serves as the parent replica.) in a replica set.
Local Use to control topology.
Anonymous Use to control topology/Internet.

ShowRecommended for a disconnected environment on the Internet

Global Yes
Local Yes
Anonymous Yes. Anonymous replicas are recommended for Internet applications if you need a large number of replicas.

ShowRecommended for custom applications on the Internet

Global Yes
Local Yes
Anonymous Yes. Use the Internet as a distribution mechanism for a large number of replicas.

ShowUse for replica creation

Global Yes. Create a global, local, or anonymous replica.
Local Yes. Create new local replicas.
Anonymous Yes. Create new anonymous replicas.

ShowUse as a Design Master

Global Yes. When a database is replicated, the first replica that is created (the Design Master) is a global replica.
Local No
Anonymous No

ShowDatabase replica visibility in Access 95 and 97

Global Default.
Local Not applicable. Don't exist in these versions.
Anonymous Not applicable. Don't exist in these versions.

ShowWhere conflict resolution is handled

Global Conflict (conflict: Can occur if data has changed in the same record of two replica set members. When a conflict occurs, a winning change is selected and applied in all replicas, and the losing change is recorded as a conflict at all replicas.) resolution can be managed at any global replica.
Local All conflicts are recorded and resolved at the hub (hub: A global replica to which all replicas in the replica set synchronize their changes. The hub serves as the parent replica.) (global) replica.
Anonymous All conflicts are recorded and resolved at the hub (global) replica.

ShowWhere synchronization can occur

Global Synchronizes with any global replica in the replica set, or any local or anonymous replica that the set created.
Local Synchronizes only with its hub (hub: A global replica to which all replicas in the replica set synchronize their changes. The hub serves as the parent replica.) (global) replica.
Anonymous Synchronizes only with its hub (global) replica.

ShowWho can schedule synchronization

Global Replication Manager can schedule synchronization with any global or local (child) replica. Synchronization cannot be scheduled with anonymous replicas.
Local Hub (hub: A global replica to which all replicas in the replica set synchronize their changes. The hub serves as the parent replica.) replicas can schedule synchronization with a local replica. And local replicas can schedule synchronization with their hub (global) replica.
Anonymous Anonymous replicas can schedule synchronization with their hub (global) replica.

ShowBriefcase support for synchronization

Global Yes
Local No
Anonymous No
advertisement