>>The .cdx files are supposed to be compact but over a period of time they tend to increase in size.
>>
>>In Fpw26 you could periodically delete all .cdx files and recreate them. But in Vfp if the tables are part of a database, you can not delete the .cdx files since when you open the database, vfp gives an error message.
>>
>>Is there a way to re-create the .cdx files so that they remain true to their name?!
>>
>>Please tell me if you have found a way!
>>
>>Eswar
>>26.06.98
>>India
>
>Simply issuing REINDEX (of course, you need exclusive access) will do the job. However, I don't know if it compacts them as much as completely re-building them does.
The problem with reindex is that it gets info from header. If this is corrupt, you get corrupt index.
Mark McCasland
Midlothian, TX USA