Is replication possible with Access 97 without the replication manager   

Hi,

We have been doing a project in vb ver 5.00, where the database is in
MS Access 97.
I have a Microsoft access97 database without the replication
manager .
I have read up on David fenton's site on replication, and have
downloaded the mstrans40, and mstrai35.exe, mstran40.exe  files.I have
also gone through the trigeminal sites on the same issue.

My question is , will the indirect replication and tsi sysnchronizer
work with Microsoft access 97 database.

We have a main database in the office. And the replicas are
distributed on different isolated sites , which have dial up
connection only.

We intend to put a database on  a web site, and then synchronize with
the replicas on the distributed sites.

How do I go about doing the replication

date: Thu, 3 Jan 2008 02:23:13 -0800 (PST)   author:   Sherry Oommen

Re: Is replication possible with Access 97 without the replication manager   

Sherry Oommen  wrote in
news:b53f34f8-430f-40c3-9519-c62e7bc3d001@x69g2000hsx.googlegroups.co
m: 

> We have been doing a project in vb ver 5.00, where the database is
> in MS Access 97.
> I have a Microsoft access97 database without the replication
> manager .
> I have read up on David fenton's site on replication, and have
> downloaded the mstrans40, and mstrai35.exe, mstran40.exe  files.I
> have also gone through the trigeminal sites on the same issue.
> 
> My question is , will the indirect replication and tsi
> sysnchronizer work with Microsoft access 97 database.

Yes. You just want to make sure you are using the Jet 3.5 versions
of these files. 

> We have a main database in the office. And the replicas are
> distributed on different isolated sites , which have dial up
> connection only.
> 
> We intend to put a database on  a web site, and then synchronize
> with the replicas on the distributed sites.

Using Internet replication? Does the web site allow you to run the
synchronizer full time? The Internet replication synchronizer is a
different program than the one for indirect, but it's the same
principle. 

> How do I go about doing the replication

Why not set up a dialup server and have them dial into that, instead
of mucking around with a website and all the problems of Internet
replication (the main issue with that is the dependence on IIS, and
the fact that you can't change IP address for the hub server without
completely hosing the whole setup)? It doesn't even have to be a
server, just a workstation, even a really old one, running Windows
2000, even, could serve as the dialup server. I used to provide my
own home workstation as a backup dialup server for my replication
clients, and it was easy to set up. 

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

date: 03 Jan 2008 21:14:49 GMT   author:   David W. Fenton lid