>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 want to do this in a development environment, check out the utility DBFCompare in the VFP downloads section of the UT. Just be aware it compares structures, not data.