Backup your data first. Then you can always close all the files, delete the CDX file. Then open the table exclusively in order to recreate the CDX. As long as the DBF/FPT files are not corrupt, your data should still be there. Next suggestion is to backup daily to different media so you are not over-writing a good backup from the previous day with bad data from the current day.

>Hello Sergey,
>Please help, I have a problem.
>
>Sergey, I have a table which stores all the ocrdata in the table.
>I have created a visual basic program with foxpro database, This project will ocr all the tif files from a folder and then saves the ocr content in the table each page ocr content will be stored as one record.
>
>So, till now the client has done more than 300 thousand pages of tiff files ocr'ed.
>
>the problem is the ocrdata.cdx seems to be corrupted.
>
>ocrdata.dbf is 444 kb
>ocrdata.cdx is 1894 kb
>ocrdata.fpt is 298445 kb
>
>.cdx file is overgrown compared to .dbf file, .cdx is always supoose to be less the .dbf file size.
>
>Everyday after running the ocr program the modified date & time is changing to current date and time and we had a feeling that the data is being uploaded to table.
>
>But when the client opened the table, it is only showing 4624 records in it.
>
>Sergey, Please help is there any utility or anything available to retrieve back those 300,000 records from the table, .fpt is looks perfect when you see the size it is 298 MB.
>
>Please help sergey, My job is at stake.
>Thank you very much.