I have two different MDB files [with the same structure]. Is there an existing tool that can report the difference between the two files [row by row]?
I found a program called "MDBDiff" on SF, however the program is no longer available for download.
A:
Try using SQL Data Compare from Redgate, http://www.red-gate.com/products/SQL_Data_Compare/index.htm
and then use this trick, http://www.red-gate.com/messageboard/viewtopic.php?p=15296#15296
Ivo
2010-08-18 14:28:25
I was thinking of something of an smaller utility [similar to diff]
monksy
2010-08-18 20:16:06
+1
A:
See the following page and go down a bit for a list of utilities to compare Access databases http://www.granite.ab.ca/access/thirdparty.htm One of those might be what you're looking for.
Tony Toews
2010-08-18 21:10:02
If you are trying to compare data you could write your own code by running through the Tabledefs collection to get the list of the tables, then the Fields collection to get a list of fields. Then, still inside VBA, from the list of fields create SQL code which compares the fields in the two tables based on the primary key. You'd also need to check for records present in one table and not the other and vice versa.
Tony Toews
2010-08-19 00:55:25