Comparing data to backup version of DB (1 Viewer)
- Thread starter csoseman
- Start date
Guus2005
AWF VIP
- Local time
- Today, 06:15
- Joined
- Jun 26, 2007
- Messages
- 2,645
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
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
