How do I delete replicas from list

ptaylor-west

Registered User.
Local time
Today, 20:10
Joined
Aug 4, 2000
Messages
193
On sychronisatrion the replication box shows numerous addresses for all the replicas, how do you delete one when it is no longer needed as the list is getting quite long... you can't just highlight and delete like most other programms
 
Solution found!!!!!

A bit of searching myself, which I have tested and they both work, found the following solutions, you need to use the or solution if you had previuosly deleted and then re-created the replica (the first solution will not work in this instance)


In order to remove the deleted replica database from the synchronization list, simply synchronize with the deleted replica, and Microsoft Access will remove the replica from the synchronization list. You need to close and re-open the DB before the change takes effect.

And/or

Follow the following link that give you the code for a command button to semi-automate the process if you need to do this often from within the database

http://support.microsoft.com/default.aspx?scid=kb;EN-US;164237

or the main details reproduced form that article are as follows:

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.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom