Database Object

There are several new properties that you use when working with replication and Database objects: DesignMasterID, DefaultPartner, MostRecentSyncPartner, Replicable, and ReplicaID. Note that only ReplicaID and DesignMasterID exist on every database, whether it’s replicable or not, and the Replicable property exists only if the user creates and appends it. If a database is made replicable (by appending the Replicable property), then the additional properties DefaultPartner and LastUpdated are created by Microsoft Jet.

In addition, Microsoft Jet 3.5 supports partial replication. If you want to replicate only part of the data in a database, you can create partial replicas, which contain a subset of the data in a full replica. You use the PopulatePartial method of the Database object to synchronize any changes in a partial replica with the full replica, clear all records in the partial replica, and then repopulate the partial replica based on the current replica filters.

With the Synchronize method, you can synchronize the current database with a replica database. The MakeReplica method creates a new replica based on the current replicable database.

See Also For more information about replication, see Chapter 7, “Database Replication.”

You can use the NewPassword method to assign a new password to the database.

The behavior of the Database object’s Close method has changed in the way it closes any pending Recordset changes. For more information, see “Closing Object Variables” earlier in this chapter.