Automatically merge remote databases (tables) into the Master data

[jsccorps]

I have users who would like to work from home. I would like to have them
enter data at home and then, at a later date, I would append their tables
into the Master database. Since this would be done on a regular basis, I
would like an automated process.

My initial thought for the process (code) is:

1) import tables (from remote users) into the Master database
2) append tables

Am I on the right track? Any suggestions (or existing code) would be
appreciated.

 

[Douglas J. Steele]

Take a look at Replication: that's exactly what it's designed for.

For Jet 3.5 look at
http://support.microsoft.com/?id=164553 - replication white paper
http://support.microsoft.com/?id=182886 - replication FAQ

For Jet 4.0
http://support.microsoft.com/?id=190766 - white paper
http://support.microsoft.com/?id=282977 - FAQ

Also see
http://www.trigeminal.com - excellent replication site
http://support.microsoft.com/support/access/content/repl/replication.asp