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 / August 2005

Tip: Looking for answers? Try searching our database.

Replication LAN- VPN and replication manager

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Uelsasser - 12 Aug 2005 23:16 GMT
Hi,

first of all please excuse my English - I'm trying to improve, but ...

Configuration : I have three locations with a W2003 server + W2003
clients. The servers are connected via VPN

In location i (i=1,2,3) I have two BE databases (the FE don't make any
problems) : loc_be.md and loc1<i>.mdb.
The loc_be.mdb serve for data entry etc the loc<i>.mdb for replication
within and between the locations.

I have configured replication manager that loc1<i>.mdb and loc.mdb
synch with direct replication in each LAN (i=1,2,3)

How do I have to configure the synchronizers in location i,j so that
loc<i>1.mdb synchronizes with loc<j>2.mdb and loc<i>1.mdb synchronizes
with loc<j>3.mdb indirectly ?

Or does this topology don#t make any sense at all ?

Thanks for your answers in advance

Uli
David W. Fenton - 13 Aug 2005 02:37 GMT
> first of all please excuse my English - I'm trying to improve, but
> ...
[quoted text clipped - 13 lines]
> that loc<i>1.mdb synchronizes with loc<j>2.mdb and loc<i>1.mdb
> synchronizes with loc<j>3.mdb indirectly ?

If the synchronizers can see each other, you can set up a
synchronization schedule in Replication Manager.

> Or does this topology don#t make any sense at all ?

Absolutely!

All sounds correct already, and all you need to do is initiate a
synch between two of the synchronizers to see if it works.

I'm assuming that when you look at the Replication Manager diagram
of the replica set, you see all three of your synchronizers? If not,
that means the synchronizers don't know about each other, so can't
synch with each other.

The easiest way to rectify that is to use an Empty Partial Replica
to transfer it's knowledge about the replication topology without
needing to also transfer data (this makes the MDB very small).
Michael Kaplan wrote an article explaining how to do this when
synchronizers have become invalidated:

 http://trigeminal.com/usenet/usenet016.asp

and at the end, he cites my CEPR utility, an Access MDB that has a
dialog form that helps you create the empty partial replica for
sending to the remote site. THe direct link to the download is:

 http://trigeminal.com/samples/CEPR.zip

I recently used it to initiate synchronization between two
previously non-connected sites, and it still works just great.

Signature

David W. Fenton                        http://www.bway.net/~dfenton
dfenton at bway dot net                http://www.bway.net/~dfassoc

Uelsasser - 13 Aug 2005 08:15 GMT
Hi David,

thanks a lot - this works perfectly
Uli
 
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.