Comparing data to backup version of DB

[csoseman]

Does anyone know of a way to compare the data between a current version of your database to a backup of that same database?

 

[Guus2005]

if it is a backup, then the data should be the same. not sure why you want to check that?

one way to do it is to create a query for each table in each database.

qry1:
select * from table1 in "c:\backup\201108\database.mdb"
qry2:
select * from table1 in "c:\production\database.mdb"

qry3:
select * from qry1 inner join qry2 on qry1.id=qry2.id and qry1.field1 = qry2.field1 ...

this is the general direction.

HTH