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 / June 2006

Tip: Looking for answers? Try searching our database.

Replication Tool

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
GregH - 01 Jun 2006 06:05 GMT
Hi – I’m looking for a replication tool that works over HTTPS.  I have 100
plus users and I want to replicate back their Access database to a central
server.  I want to avoid the code writing route – prefer to just purchase a
tool.  Oh yes they are on very slow dial up connection via their ISPs.  I’ve
looked for a tool but nothing is standing out – any suggestions.

Cheers and thanks in advance
David W. Fenton - 01 Jun 2006 21:41 GMT
> Hi – I’m looking for a replication tool that works over HTTPS.  I
> have 100 plus users and I want to replicate back their Access
> database to a central server.  I want to avoid the code writing
> route – prefer to just purchase a tool.  Oh yes they are on very
> slow dial up connection via their ISPs.  I’ve looked for a tool
> but nothing is standing out – any suggestions.

There is nothing that meets your requirements. There couldn't be
because of the nature of Jet -- it can't work via a non-SMB
networking interface, except for transferring files. Internet
replication does that over FTP, but at the cost of including a
dependency on IIS on all machines on each end of the synch (that
means IIS running on all your laptops that need to indirect synch
from the field).

The only solution is indirect replication over VPNs. This works just
fine over dialup, as the bandwidth required is very small.

But that requires programming and significant infrastructure setup.
If you can't afford to pay someone for that, then replication is not
the solution.

If you've got dialup connections, you might consider hosting your
app at a central location on a Windows Terminal Server, which will
be fast enough over dialup (and can be speeded up by purchasing some
of the Citrix extensions).

Signature

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

GregH - 02 Jun 2006 09:46 GMT
>> Hi – I’m looking for a replication tool that works over HTTPS.  I
>> have 100 plus users and I want to replicate back their Access
[quoted text clipped - 22 lines]
>be fast enough over dialup (and can be speeded up by purchasing some
>of the Citrix extensions).

Thanks David - good advice - Cheers Greg
 
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.