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