ACC95: Deleted Replicas Still Show in Synchronization List

Retired KB Content Disclaimer

View products that this article applies to.

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.

Back to the top

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.

Back to the top

STATUS

This behavior no longer occurs in Microsoft Access 97.

Back to the top

MORE INFORMATION

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.
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.
Cancel the Synchronize Database dialog box, and then close the database.
Reopen the database.
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.

Back to the top

REFERENCES

For more information about replication issues and solutions, please see the following articles in the Microsoft Knowledge Base:

146884 (http://support.microsoft.com/kb/146884/EN-US/ ) ACC95: Replicated Object Replaced by Local Object in Replica

153526 (http://support.microsoft.com/kb/153526/EN-US/ ) ACC: How to Unreplicate a Database

For more information about the Synchronize method, search the Help Index for "Synchronize method."

Back to the top

APPLIES TO

Microsoft Access 95 Standard Edition

Back to the top

kbfix kbprb kbusage KB164237

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top