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