Comparing two tables

[Guest]

How can I compare two identically structured tables an flag the entries that are not identical (any change in any field)?

I had a "screw-up" witht the database and want to compare the current table information to a backup copy.

Thanks

Daniel

 

[Ed]

I make a query of each table, then combine them in a UNION ALL query using
TOTALS and COUNT on the Primary key.

Any entry that has a one count is NOT identical.

ed

How can I compare two identically structured tables an flag the entries

that are not identical (any change in any field)?

I had a "screw-up" witht the database and want to compare the current

table information to a backup copy.