Roger

I have two versions of .mdb file(the old and the new one). The application takes the backup of existing .mdb file and then makes any changes to the existing .mdb. This is new .mdb(with changes).

I want to see the difference between the corresponding tables from these two .mdb files. For example the .mdb files contain "Policies" table. This table may undergo changes(addition of new records, deletion of existing records, updation of existing records). I want to see the diferences the Visual SourceSafe style.


Awaiting your valuable suggestions,

Roger

Rory

Well in MS SQL, this should return only the rows that do not occur in both tables (i.e. differences) "SELECT * FROM table1 FULL OUTER CROSS JOIN table2". Whether it'll work with Jet is another matter!