DesignMasterID Property

Applies To

Database Object.

Description

Sets or returns a 16-byte, OLE 2 GUID, created by the Microsoft Jet database engine, that uniquely identifies the Design Master in a replica set.

Remarks

The DesignMasterID property setting is stored in the MSysReplicas system table. Setting the DesignMasterID property gives a specific replica in the replica set design-master status. The DesignMasterID property can be set only if you are at the current Design Master. Under extreme circumstances, for example, the loss of the original Design Master, you can set the value at another replica. However, setting this value at a replica, when there is already another Design Master, might partition your replica set into two irreconcilable sets and prevent any further synchronization of data.

Warning

This property should be set only at the current Design Master. Setting this property at a replica, when there is already another Design Master, can partition your replica set into two irreconcilable sets and prevent any further synchronization of data. You can set the property at another replica only if the original Design Master is lost or erased. This will designate the current replica as the new Design Master.

See Also

ReplicaID Property.

Example

This example sets the DesignMasterID property to the ReplicaID property setting of another database giving that database design-master status in the replica set.

' Open current Design Master in exclusive mode.
Set dbs = DBEngine(0).OpenDatabase(strOldDM, True)
' Open new Design Master.
set newdmdb = DBEngine(0).OpenDatabase(strNewDB)

dbs.DesignMasterID = newdmdb.ReplicaID
dbs.Synchronize strNewDB,dbRepImpExpChanges

dbs.Close
newdmdb.Close