multi-user + multi-site

[Eric nelson]

Please give me feedback on this proposed solution:

Situation is small biz with three locations not connected
by continuous network. Proposed solution is:

At the master site, split the MDB into FE & BE. Create a
REPLICA of the BE.

Take copies of the FE and the BE-REPLICA to the second
site. Periodically bring back a copy of the BE-REPLICA to
the master site, overlay the original replica with it,
synchronize and take a copy of the new original replica
to the second site.

To add a third site, create a second BE-REPLICA and apply
the second site's procedure to it. Keep the replicas
separate from each other.

Thanks for feedback.

Eric

 

[Joan Wild]

This is not a good plan. You should not be copying replicas around like
that. For an explanation, read #9 at
http://www.trigeminal.com/usenet/usenet.asp?1033

That web site has oodles of great information about replication.

Replication should be implemented between computers that are connected (even
if it is just occasionally).