Solved

Removal of replicas from MsysReplicas table

Posted on 1997-10-09
5
970 Views
Last Modified: 2006-11-17
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.
0
Comment
Question by:Carmy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 4

Expert Comment

by:ozphil
ID: 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.
0
 
LVL 1

Author Comment

by:Carmy
ID: 1956992
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
 
LVL 4

Expert Comment

by:ozphil
ID: 1956993
Great Note eh. Tells you 'this method' doesnt work when.... Well MS, tell us what DOES work.
0
 
LVL 1

Author Comment

by:Carmy
ID: 1956994
Adjusted points to 200
0
 

Accepted Solution

by:
hjack earned 200 total points
ID: 1956995
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

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question