ozphil!
Thanks for your solution and good effort. However, this method unfortunately does not remove any of these ghost replicas the user sees on the Replication Manager. These replicas are a leftover from corrupted replicas that have been replaced by now (See Note in your answer.)
I would like to get a hold on a method to simply REMOVE records on the MsysReplicas table - Yes, I know it is System table etc. but there must be a method to clean it or at least set some of the fields in it.
Main Topics
Browse All Topics
by: ozphilPosted on 1997-10-23 at 17:41:01ID: 1956991
Carmy, see if this method from Microsoft works.
I think the coding approach will do the trick if your cant see the replica name in the list.
This method was for Access95, but should work for 97.
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.