Unmatched

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

In Access there is a wizard called "Find Unmatched Query Wizard" which
compares two tables to determine if one contains data not contained in the
other. Is there a way to do this "en masse", that is to compare the data in
all the tables in one database with all the tables in another database?

Ivor
 
I believe the purpose of that query is to find records missing from related
tables. I can't think of a case where you'd want to compare "all tables" in
one database to "all tables" in another database, and how would Access know
which tables should match. If you have 20 tables in each database, which
ones would be matched up by the query? I don't get it.
 
Back
Top