>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?
>

Doug was too classy to push his own product but if you have some budget for it (not that it's very expensive) the Stonefield Database Toolkit is terrific. It handles all kinds of DBF/DBC repair and housekeeping.