Solved

Removal of replicas from MsysReplicas table

Posted on 1997-10-09
5
957 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
  • 2
  • 2
5 Comments
 
LVL 4

Expert Comment

by:ozphil
Comment Utility
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
Comment Utility
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
Comment Utility
Great Note eh. Tells you 'this method' doesnt work when.... Well MS, tell us what DOES work.
0
 
LVL 1

Author Comment

by:Carmy
Comment Utility
Adjusted points to 200
0
 

Accepted Solution

by:
hjack earned 200 total points
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

743 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now