>I have to install new software and have lost faith that I know which is the most current table to install. The Modified dates are not making sense and I made the changes so long ago that I am not remembering well what they were. My changes would have been to change the values in one or two fields. I did not add columns or rows. I would like to compare the contents of the two tables to find my changes. Can I do this through SQL or does someone have another idea?
>
>Thanks
>
>Brenda

This is like having 2 watches. How do you know which one has the correct time? If you know by looking at the data which table would then be current, you can use SQL:

select table1.keyid, table1.fieldX, table2.fieldX from table1 join table2 on table1.keyid = table2.keyid where table1.fieldX <> table2.fieldX