Error 41 During Reindex

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\invln.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

USE INVLN

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.

Also see Error 41 Manual Repair