Hi Dmitry, can you open the file in VFP normally? If so then copy it to another filename using VFP COPY TO command and see what FoxFix says about this new file.


>Hi Jos,
>Yes, I tried to load the table into the FoxFix. It immediately tell me that there are "inordinate number of errors ..." and FoxFix says that most likely the problem is with the Header Record Count, Length, or File Length. Therefore, FoxFix recommends to fix those problems first before scanning the table. FF_SCAN() is the only way I know of to correct the table header problems but it in effect trashes the table. So I am sort of in the catch 22.
>
>>Hi Dmitry. Have you tried running FoxFix on the file in interactive mode via the FoxFix app? That should tell you what it "thinks" is wrong with the file.
>>
>>
>>>I have a DBF table (with associated .FPT and .CDX) and the database container. The table has approximately 170,000 records. When I open the table (using USE command) in VFP 6 I can see all the records, no obvious problem. But after I check the table with FF_SCAN using the following syntax:
>>>

>>>iRes = ff_scan( cDbfName, -1 )
>>>

>>>
>>>the table is completely trashed. That is, when I USE the table in VFP 6 all records look garbled, completely trashed.
>>>
>>>What do you suggest could be the problem?
>>>
>>>Thank you.