[AccessD] The best way to Replicate across offices.

John,

  Indirect replication is the way to go.  What this is is a setup where each
system has a "drop box".  A file with the changes are placed there and
replication then takes place locally. Checkout the following MSKB article:

MOD2000: How to Distribute a Replica Set for Indirect Synchronization
http://support.microsoft.com/default.aspx?scid=kb;en-us;272414

  If you go to support.microsoft.com and search on "Indirect replication",
you'll get a bunch of other articles as well that may be of interest (i.e.
FAQ).

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of John Skolits
Sent: Thursday, January 30, 2003 1:28 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] The best way to Replicate across offices.


I need some advice on the best way to replicate databases form 2 locations.
The platform will be Access for now. Eventually they will have a T1
connection between the to locations so I can just share the database or
eventually upsize to SQLServer.

Both sites have Hi Speed access to the net.

So what's the best method in the short run. Replication through some type of
FTP server (if even possible), VPN (Never really investigated this), Web
Enable database (never did this and would probably need help from someone),
Somehow connect to database via ODBC through the net (is that the same as
web enabling the database?)

Thanks,

John Skolits


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com