Rick,

Thanks for your reply.

I ran the code you suggested. I am getting the message 'Missing or invalid FPT file' on everly record that has data in the memo field. Is that what you mean by failing? This table has over 6000 records and there may be hundreds of 'bad' records. What to do?

Stan

>I am attempting to update the customers database by running my SDT update.exe that I have used for several years. I am getting the message that the FPT file for one of the tables is missing or invalid.
>
>I backed up the tables and DBC files before running the update.exe and the table in question is OK. I can open it and browse it. The issue seems to be that the update.exe 'thinks' there is a missing or invalid FPT when there isn't. I have tried copying the good backed-up files into the original folder they were from where the update is being executed and that does not work.
>
>Any ideas or suggestions?
>Thanks very much.


I have seen this when there are corrupted records.

Write something simple like:

SCAN
WAIT WINDOW TRANSFORM(RECNO()) NOWAIT
SCATTER MEMVAR MEMO
ENDSCAN
It will fail on the bad record. To correct it, load that table in the hexeditor and change the 4-byte memo data to all ASCII-0 bytes.