Synchronizing 2 databases

C

Claudia

I changed data on 2 different versions of my Access 2003 database by mistake.
How can I synchronize them?
 
T

Tom Wickerath

One approach, although it could be a bit tedious depending on how many
changes you made, and to how many tables, would be to make a copy of one of
the databases. Then import all tables from the other database into this
table. Now you can use the query wizard to construct a series of unmatched
records queries. You'd need to create two queries to compare each set of
tables.

The easy way, if you are willing to make an investment in the software, is
to purchase a copy of Total Access Detective from FMS:

http://www.fmsinc.com/products/detective/index.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I changed data on 2 different versions of my Access 2003 database by mistake.
How can I synchronize them?
 
T

Tom Wickerath

Correction: The sentence below that reads:
"Then import all tables from the other database into this table."

should have read:
Then import all tables from the other database into this new database.

Tom
__________________________________________

:

One approach, although it could be a bit tedious depending on how many
changes you made, and to how many tables, would be to make a copy of one of
the databases. Then import all tables from the other database into this
table. Now you can use the query wizard to construct a series of unmatched
records queries. You'd need to create two queries to compare each set of
tables.

The easy way, if you are willing to make an investment in the software, is
to purchase a copy of Total Access Detective from FMS:

http://www.fmsinc.com/products/detective/index.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I changed data on 2 different versions of my Access 2003 database by mistake.
How can I synchronize them?
 
Top