Barbara,

Yes, I agree. I like your suggestion and already referenced this message to my colleague, who wrote CompareTables utility. I may go ahead and work on it by myself.

Very neat idea.

>Nadya,
>Perhaps I should have included suggestions for appending any records that didn't match into a table (or 2 tables) which could then be compared on a field by field basis, but Jim wasn't completely clear on how far he needed this taken. However, I still think CompObj() will give quicker results if the percentage of non-matching records is low. I gives you a MUCH smaller set for testing with afields().
>
>Barbara
>
>
>>Hi Barbara,
>>
>>This method tells you, if there is a difference, but how would you obtain the fields name, which are different and the values? You still have to iterate through afields() then.