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