I want to compare two Access 2000 database files. And find out what records have been changed.
Is there a program to compare two files?
Printable View
I want to compare two Access 2000 database files. And find out what records have been changed.
Is there a program to compare two files?
You would have to do a query between each table between
databases.
Since M$ designed Access in a "certain" way, even if the two
databases contained the exact records, using something like
WinDiff wont work because it looks at binary comparisons. Access
dbs will not be the same even if they were exact duplicates, if
one was opened up just to look. When it closes the database is
actually changes file binary wise. But try WinDiff without opening
the dbs, if you can. Otherwise it wont work and you will have to
revert to running multiple differential queries.
HTH