Replication and splitting for Dummies

[Guest]

I have read several posts on replication and splitting but would love someone
to confirm I'm on the right track before I start:

I have an Access 2003 DB set up to log drill core data in the field onto a
tablet PC. I want to update a master DB on the network from up to 4 tablets.
The DB has forms and macros that may require updating.
Ideally when I plug in and sync the tablet with the PC the data from the
tablet is copied into the master DB and the replica copy is updated with any
changes to the macros/forms etc. However I believe replicating the entire DB
can cause corruption during syncing, so...
I must split the master DB into a FE and BE, put a copy of the FE on each
tablet and a replica of the BE on each tablet. When I sync, the data from
the tablet replica BE will be copied onto the Master. Any updates to the FE
will have to be copied over to the tablets individually.

Is all this correct?

Finally does the BE replica on the tablets contain the entire DB or is it
possible to have the replica only contain current/recent data (ie the data
log for the current drill hole only)? Such as set up the sync to move data
rather than copy into the master?

Thanks and apologies for the long winded description.

 

[Guest]

Hi Al,

I must split the master DB into a FE and BE, put a copy of the FE on each
tablet and a replica of the BE on each tablet. When I sync, the data from
the tablet replica BE will be copied onto the Master. Any updates to the FE
will have to be copied over to the tablets individually.

Is all this correct?

Sure is!!!

Finally does the BE replica on the tablets contain the entire DB or is it
possible to have the replica only contain current/recent data (ie the data
log for the current drill hole only)? Such as set up the sync to move data
rather than copy into the master?

Sure does... that's why it's called a Replica!! Don't worry about bandwidth
issues though, as the replica will only upload/download changed records when
you synchronise, not the entire database. Don't forget to occasionally open
the BE on the server to resolve any Synchronisation Conflicts.

One of my clients is using a similar method with notebook PC's and they
synch on the network, on a wireless network and over a vpn - all no worries.

Hope this helps.

Damian.

 

[Guest]

Thanks mate,

much more clear on it now.

Al

Hi Al,


Sure is!!!


Sure does... that's why it's called a Replica!! Don't worry about bandwidth
issues though, as the replica will only upload/download changed records when
you synchronise, not the entire database. Don't forget to occasionally open
the BE on the server to resolve any Synchronisation Conflicts.

One of my clients is using a similar method with notebook PC's and they
synch on the network, on a wireless network and over a vpn - all no worries.

Hope this helps.

Damian.