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

Tip: Looking for answers? Try searching our database.

Indirect sync

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JACK GUNAWAN - 03 Mar 2006 05:05 GMT
Hi, i have trouble with indirect sync with modems.  first how can i connect
the main computer using laptop with modem? second with indirect syncronize,
how can i 'tell' the syncronizer whether my replica on the laptop so as to
syncronize.  third, approximately how long to syncronize to finish with 25 mb
database with a modem of 56kbps.
there is no instruction on the installation of indirect replication on modem
on the net.  thanks for the help

I am comfused.

jack
David W. Fenton - 03 Mar 2006 20:05 GMT
> Hi, i have trouble with indirect sync with modems.  first how can
> i connect the main computer using laptop with modem? . . .

You have to setup RAS on the incoming machine so that it's waiting
for the phone to ring and will pick up when it does. Then you have
to set up a simple dialup networking connection on the remote
machine. You can execute a dialup networking connectoid by using
Shell() to call RunDLL and calling the name of the connectoid (which
is case-sensitive, unlike just about everything else in Windows). If
you search Google Groups on RunDLL and dialup networking (and maybe
connectoid) you'll find instructions. I know I've posted such
instructions in the past in comp.databases.ms-access, though I've
never used it with NT-based versions of Windows.

> . . . second with indirect syncronize,
> how can i 'tell' the syncronizer whether my replica on the laptop
> so as to syncronize. . . .

Once you're connected, then you have a standard SMB networking
connection and the synchronizer on one machine should be able to see
the dropbox on the other machine (and vice versa). At that point,
you should be able to initiate the synch.

One thing you might do is a loop with Dir() command looking for the
remote dropbox path, and once it's found, that means your connection
is up and ready to synch.

> . . . third, approximately how long to syncronize to finish with
> 25 mb database with a modem of 56kbps. . . .

It's not a function of the size of the database but of the amount of
changes you've made to your data. I've done it over 28.8 and
single-channel ISDN (64K) and a database that was being regularly
used by a dozen users in two offices never took over 10 minutes to
synch -- indirect replication is *very* efficient.

Of course, the more often you synch, the more efficient it is, since
it has fewer generations of changes to synchronize.

> there is no instruction on the installation of indirect
> replication on modem on the net.  thanks for the help

There's not much in the way of documentation for Jet replication
anywhere. This newsgroup is it.

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.