>>>>Hi,
>>>>I have a old client that has contacted me because he is getting strange results from queries etc.. There are several tables in the DBC that
>>>>will not pack (this is VFP6) and they are very large (all three over a gig each). I have a tool "ADR" from the past and I used on the tables.
>>>>The tool did not repair the tables, fpt's, and cdx's. It did create tablename_fixed.* files but they too will not pack. Strange - two of the tables will
>>>>allow" pack memo". Also the same two dbf's will allow a reindex. The error message is "Data mismatch" and then stops.
>>>>
>>>>Does anyone have a suggestion or a better tool to fix the tables?
>>>>
>>>>Johnf
>>>
>>>What happens if you remove the index file, then PACK?
>>
>>The first thing that will happen is you'll get an "index file missing" error, won't you? It's been a long time since I saw one of those so maybe I am out of date.
>
>After removing the CDX, when you first re-open the table you get an error -- ignoring the error will remove the header tag indicating that there is a CDX. Subsequent tries to open table should not get that error.

OK, thanks.