Article ID: 170493
Article Last Modified on 1/20/2007
APPLIES TO
- Microsoft Access 97 Standard Edition
This article was previously published under Q170493
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
A replica that you have deleted or moved still appears in the Synchronize With list box when you select Replication on the Tools menu and then click Synchronize Now. The replica also appears in Replication Manager when you click All Replica Sites on the View menu.
CAUSE
Deleted or moved replicas are not automatically removed from the available list of replicas that can be synchronized.
RESOLUTION
If you want to remove a replica that no longer exists from the list of available replicas, follow these steps:
- On the Tools menu, click Replication, then click Synchronize Now.
- Select the replica in the Synchronize With list and click OK.
- Click OK in the message box that tells you that the replica can't be found.
- Click Yes in the message box that tells you Microsoft Access has deleted the replica and asks if you want to close and reopen the database now.
Note that in some cases the database does not close; however, the replica name is removed from the list. If this happens, click Cancel in the Synchronize Database dialog box to reset the database.
MORE INFORMATION
Steps to Reproduce Behavior
- Open the sample database Northwind.mdb.
- On the Tools menu, click Replication, and then click Create Replica.
- When the replica is created, note the folder to which Microsoft Access copies the replica.
- On the Tools menu, click Replication, and then click Synchronize Now. Note that the new replica appears in the list of replicas that you can synchronize with.
- Using Windows Explorer, find the replica and delete it from the folder.
- Return to Microsoft Access and on the Tools menu, click Replication, and then click Synchronize Now.
Note that the replica still appears in the list, and if you try to select it, you receive a message that Microsoft Access cannot find the replica.
REFERENCES
For more information about replication, search the Help Index for "replication manager, creating replicas."
Keywords: kbprb KB170493
