multi-user + multi-site setup

[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

 

[Tony Toews]

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.

I'd suggest asking in the replication newsgroup.

BTW as you've indicated you do *NOT* want to replicate the FE. Just
the BE.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm