Compare 2 databases and create third?

[lifeson]

Is it possible using Access to do the following:

compare all tables and records from database "A" with all the tables from database "B" (which will be exactly the same structure) and put any differences in new tables database "C"?

or would it be easier to import the tables into two excel workbooks and compare the workbooks? :think:

If it is possible any pointers in the right direction would be greatly received :thumb

[OBP]

lifeson, I can't see why you would need to do this, but yes of course it is possible.
I would create the "C" database as a Copy of either of the other two using "Structure" only.
You can then set links to the other two databases and use "Find Unmatched Queries" to compare the data and populate the "c" database Tables with any records found.

[lifeson]

OBP
Thanks for the reply sounds promising.
The reason for doing this is:

Each month a new database is generated from our main system to use by field based laptop users in a programe which uses the databas as the data source.
Data is supplied to our data input team each month who manually input all the data. The new database is generated and then has to be tested.
So we would want to compare last months database with the new extract and confirm what changes have been made.
The databases are quite large (50+ MB) and contain around 200 tables
Would the option you suggest be the most efficent?

[OBP]

lifeson. it depends on your definition of "Effecient", Queries run faster than Visual Basic, but Visual Basic may be quicker to "Set Up".
Have you considered "Synchronising" the databases, using the "Briefcase" method?