The purpose of replication in Access

[Guest]

This may be the wrong discussion group, but here goes.

I've been looking at replication in MS Access 2002. No matter how I try, I
can't find information on the purpose of replication. I have done what is
needed, and actually have completed the process on a copy of a very elaborate
family database, but even with that done, and the talk of design masters in
the Help system, I really don't know what I've accomplished.

None of the training manuals I have even mention this topic. (I taught Basic
Access for a time.) Can anyone help?

 

[Joan Wild]

I've been looking at replication in MS Access 2002. No matter how I try, I
can't find information on the purpose of replication. I have done what is
needed, and actually have completed the process on a copy of a very
elaborate
family database, but even with that done, and the talk of design masters
in
the Help system, I really don't know what I've accomplished.

So why did you do it? What did *you* hope to accomplish?

Replication allows disconnected users to add/modify data. When they return
to the office (or connect in some way), they synchronize their changes. An
example would be a travelling sales force. They can use the database while
out of the office, and then connect and synchronize.

By the way, replication is meant only for data. You should not replicate
any of the other objects, except tables.

Some references:

http://support.microsoft.com/?id=190766 - white paper
http://support.microsoft.com/?id=282977 - FAQ

Also see
www.trigeminal.com - excellent replication site
http://support.microsoft.com/support/access/content/repl/replication.asp

If you have further questions, I'd suggest you ask in the
microsoft.public.access.replication group You'll find it under English;
Developer - Office Solutions; Access; replication.