Packing or copying are rarely fix corruption. You need a good file fix tool such as FoxFix.
>OK this is a first for me. I have a table "emwosb" that is corrupt but I can't fix it.
>
>reccount() = 424625
>pack
>reccount() = 424625
>copy all to testdbf
>use testdbf
>reccount() = 424621
>
>In a program I use "emwosb" and then set a filter. Then attempt to "scan". The program just sends the CPU to 50% but does not move forward (to the next statement).
>
>I have:
>select emwosb
>copy all to table
>zap
>append from table
>
>Still the scan fails.
>
>The table is indexed and I have removed the index (cdx) and it still goes nuts on the scan.
>
>I have removed the table from the DBC. Used the table as a free table copied the records to a new table renamed and then added back into the DBC. Same issues.
>
>Anybody have a suggestion on what to do next?
>
>John
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer