>I have 2 database with mulitple tables. These are suppose to be identical (ie: backup)
>
>What way would be the most efficient to compare 2 tables to make sure that all fields in each record is the same in both tables.
>
>Thank you in advance for suggestions to accomplish this.

If you need to only know data is exactly same then you could do a select ordered by primary key into 2 new tables. Compare dbf (and fpt) with:

filetostr("table1.dbf")==filetostr("table2.dbf")

Cetin