General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only