Cyrus,

>Actually, in order to CREATE the CDX from the memo field, requires the table to be OPEN. When error 114 occurs, one can NOT open the table.
>

You wouldn't put the CDX file in a memo field in the same table...you would have one table that contains one entry for each of the other tables in the system. You would put all of the empty CDX files into a memo field in this one table.

>So we are back to copying the cdx from another folder, which is really more like "RESTORE From Backup" than it is "REPAIR".

REINDEX makes a new index file anyway. It is just better not to do that if you have corruption, because it may not know the proper index expression any more. So, you can copy an empty CDX file, or, you can store all of the index expressions in a table (or in a program file), and issue an INDEX command to create the new index.

>
>I can't believe with all the power of vfp8, one still can not simply "repair" a damaged INDEX file (without having to RESTORE from backup).

See above...

>
>Wow. That is a moment of zen....

:)

Also, when delete a CDX file, you should be able to USE the table. VFP will drop the association with a CDX.

Have you deleted the .DCX file, as Garrett has suggested? It is the index for the database container.