>Hi all,
>
>I have a table with 2 Memo fields. I got an error message that the FPT file is curropted. I gues only a few of the memo fileds are corrupted hence I can use fileds there. I need to find teh ones that are damaged...
>
>Is there any easy why doing that?
>I can't zap the teble...
>
>Thanks,
>
>Gadi Hutt
Hi Gad,
First, make a backup of the damaged table files, i.e., the .dbf, .fpt and the .cdx if there is one. If you are able to open the table with the corrupted .fpt file, try copying the table with the COPY TO command. Call the new table "test.dbf." You will have to open the damaged table, then issue COPY TO test.dbf command. After the table has been copied, you should be able to open test.dbf and the .fpt should be OK. If it is OK, you can then rename test.dbf, test.fpt and test.cdx to the original name of your table and delete your damaged table.
If this does not work, you may have to use a product like FoxFix or Stonefield Database Toolkit to repair the memo field.
HTH
Thanks,
TFISHER