How can I transfer Design Master status to another replica member?
Microsoft Access 97 allows transfer of the DM status by using the UI (Tools/Replication/Synchronize Now). In the ‘Synchronize Database
. Some people have tried to use replication as a limited form of version control. Although it does not keep historical information, it does allow you to limit changes to one developer at a time. The act of “checking out” the database is simply transferring Design Master status to that replica. This technique, however, is not a good idea unless you synchronize very frequently, because you can get into a state where some replicas become confused as to who the Design Master is and how to apply schema changes that the different Design Masters have made. • How can I detect that the current replica member is the Design Master? If the ReplicaID is equal to the DesignMasterID, then the database name passed as an argument to this function is the Design Master, as shown in the following code: Public Function IsDesignMaster(strDBName) As Boolean Dim dbs As Database ‘ Initialize return code to False IsDesignMaster = False ‘ Open Database passed as argument Set dbs = OpenDatabase(strDBName) If Len(
