Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Replication / February 2006

Tip: Looking for answers? Try searching our database.

removing members from a replica set

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Eric Johnson - 06 Feb 2006 20:00 GMT
I'm relatively new to replication in Access DBs, and have run into a problem
I haven't been able to quickly solve.

In moving data around, and re-designating the Design Master as a design
master after having moved data, I've ended up with lists of old replicas
(paths to them, actually) in the pick list when I go to
Tools>Replication>Synchronize Now, under "Synchronize directly with
replica."

A reference I've got says that I can attempt to synchronize with the (no
longer existing) files at these paths, be notified with a warning that they
don't exist, and upon reopening the DM the next time, those records will be
gone from the picklist.

It's not working, unfortunately ... the records are still there upon
restart.  I'd like to get this cleaned up, but am not sure where to go next.
I can see records for these paths in table MSysReplicas, but can't edit that
table -- not that I'd know what I was doing if I could.

Thanks for any suggestions of solutions/workarounds that you may have.

-- Eric Johnson
David W. Fenton - 06 Feb 2006 20:22 GMT
> I'm relatively new to replication in Access DBs, and have run into
> a problem I haven't been able to quickly solve.
[quoted text clipped - 9 lines]
> warning that they don't exist, and upon reopening the DM the next
> time, those records will be gone from the picklist.

That's the correct method, but it leaves out the final steps of the
process.

> It's not working, unfortunately ... the records are still there
> upon restart.  I'd like to get this cleaned up, but am not sure
[quoted text clipped - 4 lines]
> Thanks for any suggestions of solutions/workarounds that you may
> have.

After you've synched from the DM with all the dead replicas, you
then need to synch around your full replica set. You may also need
to attempt a synch with the dead replicas from every one of the live
replicas.

It can be done -- I've done it.

But it's not as simple as doing it from one replica. You have to
purge the entries from the MSysReplicas table in all the replicas
before it will all go away.

And, yes, there's a bit of voodoo to this explanation, as sometimes
you don't have to do the whole process, and sometimes you do.

Keep in mind also that a single replica path/filename in the
dropdown list can represent an infinite number of unique replica IDs
that were possessed by MDBs at that location with that name. So, you
could see one item in the dropdown list, but it could represent
dozens of replicas in the MSysReplicas table. You have to attempt
the synch with the dead replica as many times as there are unique
ReplicaIDs listed at that location in MSysReplicas.

And, of course, this is why it's such an incredibly bad idea to move
or copy or rename replicas after they are already in use.

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.