Removal of replicas from MsysReplicas table

If you corrupt a replica, you will probably need to recreate it from
scratch.  This is not so much of a problem, but what is a pain in the xxx
is that the Replication Manager thinks it is still there the Map is showing
the replica as per normal.
So,  How do you delete this entry?
I understand that this is actually an entry in the MsysReplicas but I have
no idea as to how to remove it from there.  Some entries can be removed by attempting to synchronise with them using the Access Menu and selecting an entry from the list, but others do not make themself available on the list and consequently do not lend themselves to be removed from the list.
I need to know of a method to remove any Replica i choose to from the MsysReplicas table.
LVL 1
CarmyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ozphilCommented:
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.
0
CarmyAuthor Commented:
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.
0
ozphilCommented:
Great Note eh. Tells you 'this method' doesnt work when.... Well MS, tell us what DOES work.
0
CarmyAuthor Commented:
Adjusted points to 200
0
hjackCommented:
I have been on the phone to MS for a week about replicas and just having read writes throught the Jet-Engine to VB...

this code gives you rights to the system tables..
    Set DBEngine = Nothing
    DBEngine.SystemDB = "c:\windows\system\system.mdw"
you then set your database object normally etc...
I have never tried to alter the contents of system tables using this, I use it for read purposes only... but MS told me that you could --- they went on and on about how they wouldn't support me if I altered the contents of a system table...

hope it helps...I'd enter this as a comment, but on the off chance it works, what the hell...

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.