By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,321 Members | 1,909 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,321 IT Pros & Developers. It's quick & easy.

Partial Replication of Data

P: n/a
Hi

Is there a way to do partial replication of data?

I'm looking at having a central back end data file which contains all the
data from all users. But when each user synchronises the mobile data files
with the main data file, I only want data which is relevant to that user to
be synchronised to their data file.

Example:
Main File holds records
1, 2, 3, 4, 5

User 1 records User 2 records
1, 2 3, 4, 5

************************************************** **
User 1 adds records User 2 adds record
6, 7 8

Main File adds records
9 (for user 1)
10 (for user 2)
After synchronising:
User 1 records User 2 records
1, 2, 6, 7, 9 3, 4, 5, 8, 10

Data Fie holds records
1, 2, 3, 4, 5, 6, 7, 8, 9, 10
Jeff
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Wed, 14 Sep 2005 00:11:31 +1200, "Jeff Smith"
<No****@Not.This.Address> wrote:

Yes.
Partial replicas are explicitly supported. Didn't you come across this
term in the help file?
Replication is an advanced topic. Only use it as a last resort.

-Tom.
Hi

Is there a way to do partial replication of data?

I'm looking at having a central back end data file which contains all the
data from all users. But when each user synchronises the mobile data files
with the main data file, I only want data which is relevant to that user to
be synchronised to their data file.

Example:
Main File holds records
1, 2, 3, 4, 5

User 1 records User 2 records
1, 2 3, 4, 5

************************************************* ***
User 1 adds records User 2 adds record
6, 7 8

Main File adds records
9 (for user 1)
10 (for user 2)
After synchronising:
User 1 records User 2 records
1, 2, 6, 7, 9 3, 4, 5, 8, 10

Data Fie holds records
1, 2, 3, 4, 5, 6, 7, 8, 9, 10
Jeff


Nov 13 '05 #2

P: n/a
"Jeff Smith" <No****@Not.This.Address> wrote in
news:dg**********@lust.ihug.co.nz:
Is there a way to do partial replication of data?
Yes, but it has its limits. You have to have a relatively simple
filter.
I'm looking at having a central back end data file which contains
all the data from all users. But when each user synchronises the
mobile data files with the main data file, I only want data which
is relevant to that user to be synchronised to their data file.


Why bother? Use your application to restrict them to their own data.

Another reason to not use partial replication is because it give
syou automatic backups. If you have only one replica with all the
data in it, and only partial replicas, you could lose the main
replica and be unable to recreate it, except without a great deal of
work.

You should look into the subject of partial replication as
documented in the Access help files and see where that gets you.

I've never found it useful, except for the special case of the empty
partial replica used to activate a remote replica set that's got
problems.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #3

P: n/a
Tom van Stiphout <no*************@cox.net> wrote in
news:ij********************************@4ax.com:
Replication is an advanced topic. Only use it as a last resort.


Well, I wouldn't say "last resort" -- I'd say, only use it if you're
prepared to do the work to make sure you're doing it right.

Much of Access is designed to be easily used by novices and
non-programmers. Replication is *not* one of the capabilities of
Access that falls in the "for novices" class. You really have to
know a lot about desiging proper data schemas, Windows networking,
and VBA programming before you should embark on replication.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #4

P: n/a
> > Is there a way to do partial replication of data?
Why bother? Use your application to restrict them to their own data.

Another reason to not use partial replication is because it give
syou automatic backups. If you have only one replica with all the
data in it, and only partial replicas, you could lose the main
replica and be unable to recreate it, except without a great deal of
work.

You should look into the subject of partial replication as
documented in the Access help files and see where that gets you.

I've never found it useful, except for the special case of the empty
partial replica used to activate a remote replica set that's got
problems.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc


Thanks David. I found the documentation for partial replication was in the
VBA help file. I'll probably take your advice on restricting the access to
the data via the application. Handy advice about the potential problems with
losing the full replica because it's the only one with all the data in it.

Jeff
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.