Re: Replication to laptops - how do you do this?
- From: McDal <McDal@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 8 Mar 2006 12:51:27 -0800
David,
I wasn't thinking the synchronization process all the way through for the
way we need to perform it.
We have a main office (in PA) which has the server. Then we have 6 laptops
out in the field gathering information into the replica. They can login from
home via the internet or walk into the office and connect to the server.
Then we have a branch office (in NY) which has 4 laptops in the field. We
need those 4 to connect and synch up to the version onthe branch office PC
(in NY0 and then synch that PC version up to the server in the main office
(in PA). So I don't know which is the best synchronization method to use.
Could you advise me on a solution? Thanks so much for all your advise from
your last post.
"McDal" wrote:
David,.
THANK YOU SO MUCH! This is the kind of information I've been looking for
and I think you answered everything I asked! I can't thank you enough.
We are a service company and I send the technicians out to plants to inspect
equipment. They are supposed to use this new access database program that I
wrote to input the information. Then when they can, the information is to be
synched back up to the server in the main office where we print the reports
for the client on the inspection and do other stuff with the data. I've been
reading for days and was convienced I need to use indirect synch. But you
suggest otherwise. I will reread the information you gave me and roll this
project out...FINALLY!
I now just need VB code to do the synchronization on startup ...you wouldn't
happen to have a copy of the code?
Once again...Thank you :)
"David W. Fenton" wrote:
McDal <McDal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:B15EB253-03AE-40D8-8721-29393AD5EE3E@xxxxxxxxxxxxx:
I want to replicate my database and put it on a server and laptop
and synchronize them.
Here's what I've done....created a split version of the db called
db6.mdb (front end)
db6_be.mdb (back end)
then I secured it and called it:
db6.mde (secured version) which I'm guessing is my front end only
So at this point I want to replicate it.
What is "it"? The front end or the back end? If you're thinking of
replicating the front end, then STOP. Replication does not work with
front ends -- it only works reliably over the long term with data
(pure Jet objects, i.e., tables and queries).
I have 10 laptops. Do I create 10 replicas (replica set) or do I
just create one replica and then use the "move replica" tool?
If you move a replica, you aren't creating a new copy -- you're only
moving it somewhere else.
It's unclear what you want to do or why. The only scenario with
laptops and a server that makes any sense is if you have users who
need to take their laptops out of the office to places where they
can't connect back to the mother ship via the Internet (in order to
run the app on Windows Terminal Server). If that's the case, then
each laptop needs to have a replica of the data file (the back end).
What you need to do is this:
1. move your existing back end into a protected folder that will not
be accessible to most users. Once you've replicated, it will be your
Design Master, which is why it needs to be in a protected location.
2. open it there and replicate it. Put the new replica back in the
location where the back end was before. This will be the production
replica used for editing by users connected by wire to the server on
the LAN.
3. for each laptop, copy that replica over to the laptop into its
final location on the laptop.
4. copy the front end to the laptop and relink it to the tables
local to the replica on the laptop (instead of to the tables in the
replica on the server).
Now, normally, a copy is not something you want to do, but since you
are initializing the new replicas on the laptop, and they haven't
been edited yet, it's OK. Once you've opened a replica in its final
location, though, you don't want to move it except via the MOVE
REPLICA command in Replication Manager, the TSI Synchronizer or JRO.
If you feel uncomfortable about that, you can open Access on the
laptop, open the shared back end replica on the server and create
the new replica in place on the laptop. This will have the advantage
that the server replica will already know that the laptop replica
exists. However, that advantage lasts only until the first synch
from the laptop to the server.
To synch, open the back end on the laptop and use the Access menu
commands to synch. You can also program a simple form in your front
end to do this. I always recommend having a synch occur at
application startup and unload (the code checks to see if the LAN
replica is available and then synchs with it).
None of the above involves anything but plain and simple DIRECT
replication, because it's all happening across a wired LAN, which is
perfectly safe and efficient and fast.
I read somewhere that I have to create a "dropbox" on the laptop
(a folder I'm guessing) . . .
That's only if you're using indirect replication. You need indirect
replication only for users who have to synchronize with the "mother
ship" across a low bandwidth connection (dialup or Internet). For
all users who can bring their laptops into the main office and
connect to the LAN, you don't need to set up indirect replication --
they can just use the Access interface to perform a direct synch.
. . . . and then create the same names on the server and then
transport that data from the dropbox on the laptop to the server
and then synchronize them to the design master?
If your users will be coming back into the main office, you have no
need to worry about any of these things.
I'm really looking for the answer to the replica question first.
Well, maybe the above will answer your questions.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
- Follow-Ups:
- Re: Replication to laptops - how do you do this?
- From: McDal
- Re: Replication to laptops - how do you do this?
- From: David W. Fenton
- Re: Replication to laptops - how do you do this?
- References:
- Re: Replication to laptops - how do you do this?
- From: David W. Fenton
- Re: Replication to laptops - how do you do this?
- From: McDal
- Re: Replication to laptops - how do you do this?
- Prev by Date: Re: Replication to laptops - how do you do this?
- Next by Date: Re: Replication to laptops - how do you do this?
- Previous by thread: Re: Replication to laptops - how do you do this?
- Next by thread: Re: Replication to laptops - how do you do this?
- Index(es):
Relevant Pages
|
