When running a reindex, if the error below appears, there is a problem with the memo fields of the table showing in the error (INVLN will be the table used on this article as example)
Error Number= 41 Message=Memo file c:\infusion\data\invidx.fpt is missing or is invalid.
If running the table through the command mode CM Repair tool does not fix the problem, try the following before running the reindex again:
Go to the corresponding data folder and make a copy of the 3 INVLN files and save them somewhere else (like a subfolder on the desktop) to keep as a backup
In command mode and type
COPY TO INVLNNEW WITH CDX
This command will create a copy of all 3 files (DBF, FPT and CDX) called INVLNNEW and these will be sitting in the Infusion root folder.
Go to the Infusion root folder and rename these files INVLN, then move them to the corresponding data folder in order to replace the old ones – make sure there is no copy left in the root folder.