Methods and properties used to programmatically replicate a database (MDB) - Access

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 link

Printer-Friendly Version Bookmark and Share

Methods and properties used to programmatically replicate a database (MDB)

Applies to: Microsoft Office Access 2003

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

You can programmatically control the exchange and 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.) of information among members in a replica set (replica set: The Design Master and all replicas that share the same database design and unique replica set identifier.) in Microsoft Access 2000 and later versions by using Jet and Replication Objects (JRO) (JRO: A set of automation interfaces that you can use to perform actions specific to Microsoft Jet databases. Using JRO, you can compact databases, refresh data from the cache, and create and maintain replicated databases.). JRO can only be used with Microsoft Access databases (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose. The Microsoft Jet database engine manages the data.) (.mdb files).

For programmatically controlling replication (replication: The process of copying a database so that two or more copies can exchange updates of data or replicated objects. This exchange is called synchronization.) with earlier databases (Microsoft Access 95 and Microsoft Access 97), you can use Data Access Objects (DAO) (Data Access Objects (DAO): A data access interface that communicates with Microsoft Jet and ODBC-compliant data sources to connect to, retrieve, manipulate, and update data and the database structure.).

Show Replication with Jet and Replication Objects (JRO)

You can create and maintain a replicated database by using Jet and Replication Objects (JRO) methods and properties.

Programming replicated databases

Use JRO with Microsoft Access databases (.mdb) if you require programmatic control over the exchange of data and design information among members of the replica set. For example, you can use JRO to write a procedure that automatically synchronizes a user's replica with the rest of the set when the user opens the database. The database must be closed to make the database replicable programmatically.

Methods

CreateReplica method

GetObjectReplicability method

MakeReplicable method

SetObjectReplicability method

Synchronize method

Properties

ActiveConnection property

ConflictFunction property

ConflictTables property

DesignMasterID property

ReplicaID property

ReplicaType property

RetentionPeriod property

TableName property

Visibility property

Methods and properties available in a partial replica

Append method

Delete method

PopulatePartial method

FilterCriteria property

FilterType property

Priority property

Show Replication with Data Access Objects (DAO)

You can create and maintain a replicated database in previous versions of Microsoft Access by using DAO methods and properties. Use DAO if you require programmatic control over the exchange of data and design information among members of the replica set. For example, you can use DAO to write a procedure that automatically synchronizes a user's replica with the rest of the set when the user opens the database.

You can use the following methods and properties to create and maintain a replicated database:

MakeReplica method

Synchronize method

ConflictTable property

DesignMasterID property

KeepLocal property

Replicable property

ReplicaID property

ReplicationConflictFunction property

Microsoft Jet provides these additional methods and properties for creating and maintaining partial replicas (replicas that contain a subset of the records in a full replica):

ReplicaFilter property

PartialReplica property

PopulatePartial method