Paige,

Doing this and respecting the DBC is a little different. For instance, if you remove a table from the DBC, you lose all of the extended properties. Therefore, you must store your attributes somewhere else so they can be put back in. This is why most folks use Stonefield.

For myself, I wrote my own before I knew what Stonefield was, and I've stuck with it because I like it. I'd be happy to send you the PRG if you want some ideas.

You can do quite a lot in VFP that you can't do in 2.x. I especially enjoy using the ALTER TABLE command, in which you can add and remove several fields in one command. There is much more.

>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