How do I synchronize local and remote access databases (2000)

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

Guest

I have a database online that collects data from users.

If I make a change to a table on my local machine, do I have to reload the
entire database or is there a way of only adjusting what has been changed -
synchronize.

Thank you.
 
There's a synchronization feature in database replication, but I caution
that replication "is not for the faint of heart".

You can use an append query to append all the records from the table in one
database to the corresponding table in the other. The records with duplicate
primary keys will be recorded as errors.

If the information you want is _updates_ to existing records, then I think
you're going to need to create some VBA code, and you'll have to figure out
how to determine which is the "authoritative data". If it is always what the
user entered into that database, then your job is simpler. You might want to
include a date/time field on both databases to make certain there's no
slipup in the date, that is causing you to overlay more recent data with
older data.

Larry Linson
Microsoft Access MVP
 
Back
Top