About split database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!! I've just recently split my database where the BE is located on the
network server and everyone else has a copy of the FE on their own
desktop/laptop. My boss travels quite frequently. I'm wondering, how can I
make it so that he can access all the data from the database from his laptop
while he's overseas and when he's back, he can synchronise it? Is there a way
to work around this issue? Your feedback will be very much appreciated.
Thanks.

Regards,
Michelle
 
Hi Michelle,

This is the scenerio that replication was designed to handle. You should
only try implementing replication on a *copy* of your database, not on the
original. I am not a replication expert, but I do advice you to download a
copy of the replication white paper from Microsoft:

ACC2000: Jet 4.0 Replication White Papers Available in MSDN Online
Library
http://support.microsoft.com/?id=190766

Here is a KB article that may also be helpful:

ACC2000: How to Make a Database Replicable
http://support.microsoft.com/?id=208774

Although both titles include "ACC2000", the information should be equally
valid for Access 2002 and 2003. I would also head on over to Michael Kaplan's
web site and read everything you can find on replication:

http://www.trigeminal.com/usenet/usenet.asp?1033


If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hi!! I've just recently split my database where the BE is located on the
network server and everyone else has a copy of the FE on their own
desktop/laptop. My boss travels quite frequently. I'm wondering, how can I
make it so that he can access all the data from the database from his laptop
while he's overseas and when he's back, he can synchronise it? Is there a way
to work around this issue? Your feedback will be very much appreciated.
Thanks.

Regards,
Michelle
 
Back
Top