Microsoft KB Archive/164237

= ACC95: Deleted Replicas Still Show in Synchronization List =

Article ID: 164237

Article Last Modified on 11/17/2000

-

APPLIES TO


 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q164237



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
After you try to synchronize with a deleted replica database, the deleted replica's name still appears in the list of databases when you point to Replication on the Tools menu, and then click Synchronize Now.

NOTE: This does not apply to replication features implemented using the Replication Manager from the Microsoft Access Developer's Toolkit version 7.0.



RESOLUTION
You can create a custom procedure that tries to synchronize with the deleted replica using the Synchronize method. If the database is not found, its name is removed from the synchronization list. Run the following procedure in each database in the replica set where you want to remove a deleted replica name from the synchronization list.

Sub RemoveDeletedReplica Dim strDelReplica as String On Error Resume Next strDelReplica = InputBox _ ("Enter the full path and name of deleted replica") CurrentDb.Synchronize strDelReplica End Sub

Type the path and file name of the deleted replica in the input box. After the procedure runs, you can point to Replication on the Tools menu, and then click Synchronize Now. Note that the deleted replica no longer appears in the Synchronize With box.

NOTE: This method does not work if you create a replica, delete it, create another replica with the same path and file name, and then delete that replica again.



STATUS
This behavior no longer occurs in Microsoft Access 97.



Steps to Reproduce Behavior
 Start Microsoft Access and create a new blank database. On the Tools menu, point to Replication, and then click Create Replica. Follow the instructions on your screen to convert the current database to Design Master and create a new replica. Repeat step 2 to create another replica. On the Tools menu, point to Replication, and then click Synchronize Now. Synchronize with one of the two replicas in the Synchronize With box. Close and reopen the database when prompted; then repeat this step and select the other replica in the Synchronize With box. Start Windows Explorer or File Manager and delete one of the replicas.</li> In Microsoft Access, point to Replication on the Tools menu, and then click Synchronize Now. Select the deleted replica in the Synchronized With box, and then click OK. Note that you receive the following error message:

Microsoft Access can't open the database '<Database Name>'. Couldn't find file '<Database Name>'.

Click OK.</li> Cancel the Synchronize Database dialog box, and then close the database.</li> Reopen the database.</li> On the Tools menu, point to Replication and then click Synchronize Now. Note that the deleted database name still appears in the Synchronize With box. The name remains even after you compact or repair the database.</li></ol>

<div class="references_section">