Microsoft KB Archive/190528

= ACC: Changes to Connect Property Don't Synchronize to Replicas =

Article ID: 190528

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition
 * Microsoft Access Developer's Toolkit 1.1
 * Microsoft Office 97 Developer Edition

-



This article was previously published under Q190528



Advanced: Requires expert coding, interoperability, and multiuser skills.



SYMPTOMS
When you use the Linked Table Manager to change the file location from which your tables are linked, or when you change the Connect property of a TableDef, the changes are not synchronized with other members of the replica set.



RESOLUTION
You can force the changed links to be propagated to the other members of the replica set by making the linked tables non-replicable, and then making them replicable again. You can do this by using the table properties or through Replication Manager.

NOTE: The table properties can only be set in the replica set's Design Master.

Changing a Table's Properties in Access

 * 1) Open the replica set's Design Master.
 * 2) In the Database Window, click the Tables tab.
 * 3) Select the first table marked as replicable.
 * 4) On the View menu, click Properties.
 * 5) Click to clear the Replicable check box.
 * 6) Click Apply.
 * 7) Click to select the Replicable check box.
 * 8) Click OK.

Repeat steps 3 through 8 for every replicable, linked table. After you have finished "re-replicating" all the tables, the changes to the linked tables will start to propagate to the other members of the replica set during synchronization.

Changing a Table's Properties with Replication Manager
If you have many tables, it may be easier to modify the table properties by using Replication Manager. Replication Manager is a utility program that ships with the Microsoft Access Developer's Tools for Windows 95 and the Office 97 Developer Edition.


 * 1) Using Replication Manager, manage the Design Master.
 * 2) Open the managed Design Master in Replication Manager.
 * 3) On the View menu, click Properties.
 * 4) In the Properties dialog box, click the Open Database tab, and then click Modify Object Status.
 * 5) In the Modify Object Status dialog box, click the Tables tab and de-select all the tables that have had their linking information changed. Then, click OK.
 * 6) In the Properties dialog box, click Modify Object Status again.
 * 7) Select all the tables that you de-selected in step 5.
 * 8) Click OK.

The changes to the linking information for the tables is now available to the other members of the replica set through synchronization. To update the other members, synchronize all members of the replica set to the Design Master. You may also synchronize the Design Master to a hub replica, and then synchronize all other members to the hub.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 7.0 and 97.



Steps to Reproduce Problem
 Make a copy of Northwind.mdb and name it "Copy of Northwind.mdb." Create a new database called DM.mdb. Link all the tables from Copy Of Northwind.mdb to DM.mdb. On the Tools menu, point to Replication, and then click Create Replica. Accept all the defaults. On the Tools menu, point to Add-Ins, and then click Linked Table Manager. Use the Linked Table Manager to relink the tables to Northwind.mdb.

<ol style="list-style-type: lower-alpha;"> Click the Select All button to select all of the linked tables.</li> Click to select the "Always prompt for new location" check box.</li> Click OK.</li> Select Northwind.mdb as the new location.</li> Click OK to confirm new location.</li> Close the Linked Table Manager.</li></ol> </li> On the Tools menu, point to Replication menu, and click Synchronize Now to synchronize to Replica of DM.</li> Delete the "Copy of Northwind.mdb."</li> Open the Replica of DM.mdb file.</li> Try to open any of the linked tables.

Note that you receive the following error message

Couldn't find file

where is the path to "Copy of Northwind.mdb" on your system. Even though the linked table information was updated in the Design Master, the new link information was not updated in the replica.</li></ol>

<div class="references_section">