Methods and properties used to programmatically replicate a database

You can programmatically control the exchange and synchronization of information among members in a replica set in Microsoft Access 2000 and later versions by using Jet and Replication Objects (JRO). JRO can only be used with Microsoft Access databases (.mdb files).

For programmatically controlling replication with earlier databases (Microsoft Access 95 and Microsoft Access 97), you can use Data Access Objects (DAO).

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

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