I am trying to implement a replicated database on the current system.
The present scenario is as follows
We have a database in MSAccess '97,without the replication Manager, in the
main office.We are using Visual Basic ver 5.oo as the front end for our
application
We have a copy of the database at different locations.
The locations are not connected by network.
The locations have a broad band wireless DSL connection.
I was thinking of implementing replication in this scenario.After all the
reading, I did on the subject in this forum, and David Fenton's sites on
replication, I assumed that indirect replication would be best .
I have put up the a replica of the database on a website , with the
replication files,
ie: MsRPFS35.DLL, MSTRAI35.EXE, MSTRAN35.EXE,RICHINK.DLL,
synch35.dll,TsiImpExp90.mde, TsiIMpExp100.mde.
I have a dropbox folder also in this site.
My idea is that the remote site locations, would connect to the website (
which would act as a hub) and synchronise with the database there.
Am I on track so far?
Also, I'm at a loss on where I would put the synchronisation code?
I saw a mention that this needs to be done in the tsi synchroniser? I
don't
understand how to? I'm thinking of an event driven button from the front
end.
Also where do I write the code for the Managedreplicas. append method?
When I first create my replicated database, should it be empty?
Please help
|
