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

[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.

 

[Larry Linson]

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