>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.
George
Ubi caritas et amor, deus ibi est