Hi
I noticed you asked a question on database splitting before and you also
mentioned replication in that thread. Replication and splitting are two
different things. Each one is performed out of certain needs which are
generally not related, neither one needs the other. Splitting is always
recommended, while replication should be used only when the circumstances
warrant it. For example, if you have remote users who need to enter data but
do not have access to the central database, then you may want to implement
replication.
Differences between a replica and a copy? A lot. I can probably say,
conceptually, a replica is a smart copy. A replicated copies of an Access
database have built in mechanism to avoid duplicates, concurrency problems,
and many others. If changes/updates are made to the same record, replicated
system can resolve which changes/updates will stand. Mere copies of Access
database would not be able to deal with the above problems, some information
will be lost.
HTH
Immanuel Sibero