replication and splitting clarified

[Guest]

I'm a little lost about the whole replication idea. I understand that it's
meant to be a backup copy for emergency situations. That's a good thing
however, I'm wondering how it works with a split database. I'm looking to
split my database to improve network speed but I'm confused how replicating
and splitting functions interact.

Do I split first then replicate? Or vice versa?

Thanks!

 

[Immanuel Sibero]

Hi John,

Do I split first then replicate? Or vice versa?

Split first, then replicate.
Only replicate your Back End (the data). Front End should be installed on
each workstation. (i.e. straight copies of Front Ends as opposed to
replicas)
I would recommend browsing the replication group to learn more about the
correct way to replicate.

I'm a little lost about the whole replication idea. I understand that it's
meant to be a backup copy for emergency situations.

Well, replication is not usually used for backup purposes. You do that with
backup tapes or drives. Could you elaborate more as to why you need
replication?

HTH,
Immanuel Sibero

 

[Guest]

I agree with Immanuel Sibero that replication isn't normally used for backing
up. The classic reason to replicate is that you have sales people each with a
replicated copy of the database on their laptops. When they are out in the
field with customers they can see what is in stock, as least what was there
when they left, and insert orders into the database. When they get back to
the office, they can sychronize their laptops with the Master, thus trading
data back and forth.

 

[Guest]

Thanks for the direction and clarification everybody.

It's interesting that you and Jerry note that replication isn't used for
backing up. Unless I read it wrong, the help file for Access states that
replication is for this very purpose. This is why I love this forum - there's
more people with insight and working knowledge here than a help file can ever
provide.

I didn't realize about replicating only the BE so I appreciate all the
comments.

Thanks!

 

[Immanuel Sibero]

You're welcome. This forum has been invaluable for me too.
Good luck.

Immanuel Sibero