>What's the best way to compare two identical tables for changes in data between one point in time and another point in time? The field structure and names is the same, but the data might have changed or gotten destroyed between the two dates that the file was modified. I would also like to print the discrepencies between the two tables. Does this mean I have to write a little program or is there a quicker and better way to compare two tables for differences in data.
>
>Thanks for letting me know, before I embark on writing a little program or reinventing the wheel. Don't you wish you had invented the wheel? The guy that invented the wheel must be wheely, wheely wich. LOL... Sorry, I am losing my mind late on Friday afternoon. It wouldn't be the first time. LOL!

It would be faster to implement an audit program that logs all inserts, edits and deletes to a log file. See also FoxAudit [which will do this for you] under Product Discounts on the UT Login Page. The price is $259 or somewhere around 4 billable hours.

Otherwise, you get to compare the data from every row in the production table to the matching row in the archived table. What a PITA that would be. Figuring out what rows have been added and deleted would be fairly easy.

With an auditing program you have log files of every change. With FoxAudit, you can rollback any data to a particular point in time. How's that for data recovery?