ACC2000: Changes to Connect Property Don't Synchronize to Replicas (207588)
The information in this article applies to:
- Microsoft Access 2000
- Microsoft Office 2000 Developer
This article was previously published under Q207588 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 within the Design Master.
Changing a Table's Properties in Access- Open the replica set's Design Master.
- In the Database Window, click Tables.
- Select the first table marked as replicable.
- On the View menu, click Properties.
- Click to clear the Replicable check box.
- Click Apply.
- Click to select the Replicable check box.
- 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
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 Office 2000 Developer Edition.
- Using Replication Manager, manage the Design Master.
- Open the managed Design Master in Replication Manager.
- On the View menu, click Properties.
- In the Properties dialog box, click the Open Database tab, and then click Modify Object Status.
- 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.
- In the Properties dialog box, click Modify Object Status again.
- Select all the tables that you de-selected in step 5 and 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.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. REFERENCES
For more information about replication, click Microsoft Access Help on the Help menu, type "replication" in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Minor | Last Reviewed: | 7/13/2004 |
---|
Keywords: | kbbug kbpending KB207588 |
---|
|