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

• Microsoft Access versions 7.0, 97
• Microsoft Access Developer's Toolkit, version 7.0
• Microsoft Office Developer Edition 97

SYMPTOMS

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

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.

Changing a Table's Properties with Replication Manager

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.

STATUS

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

MORE INFORMATION

Steps to Reproduce Problem

1. Make a copy of Northwind.mdb and name it "Copy of Northwind.mdb."



2. Create a new database called DM.mdb.



3. Link all the tables from Copy Of Northwind.mdb to DM.mdb.



4. On the Tools menu, point to Replication, and then click Create Replica. Accept all the defaults.



5. 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.
   
   
   1. Click the Select All button to select all of the linked tables.
   
   
   
   2. Click to select the "Always prompt for new location" check box.
   
   
   
   3. Click OK.
   
   
   
   4. Select Northwind.mdb as the new location.
   
   
   
   5. Click OK to confirm new location.
   
   
   
   6. Close the Linked Table Manager.
   
   
   



6. On the Tools menu, point to Replication menu, and click Synchronize Now to synchronize to Replica of DM.



7. Delete the "Copy of Northwind.mdb."



8. Open the Replica of DM.mdb file.



9. Try to open any of the linked tables.
   
   Note that you receive the following error message
   

   Couldn't find file <filename>

   
   where <filename> 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.

REFERENCES

For more information about replication, search the Help Index for "Replication," or ask the Microsoft Access 97 Office Assistant.

Keywords : kbdta OdeRplMgr RplUpd
Version : WINDOWS:7.0,97
Platform : WINDOWS
Issue type : kbbug