>Hi All,
>
>In WinFoxPro and Dos FoxPro I had a routine that USED each file in the app, set the 'primary' index, copied it to a tempfile, deleted the original and renamed the tempfile and then reindexed it. This utility was run periodically to unfrag the file and make access by the primary index faster.
>
>With DBC's I believe it is not as easy to delete and add tables. I am about to rewrite that routine to copy, zap, append from tempfile, reindex.
>
>Has anyone done this or worked out a better to keep our .dbf's reorganized? TIA.
>
>Regards,
>
>Paige

Look at Stonefield Datatools. www.stonefield.com.