Hi Dave.

>First of all, I did have a few problems using the Copy To command, primarily because my tables are part of a DBC. The relational links between my tables seemed to get broken for some reason. However, I was able to relink everything. In one case, the index seemed to become corrupted. I probably did something wrong or missed a step or two.

FYI, there's an easier and safer approach: Stonefield Database Toolkit (SDT). It's Reindex method (which doesn't really REINDEX but builds the indexes from scratch) has the optional ability to pack tables first. It doesn't use PACK but rather a SELECT * FROM TABLE to another table, then handles all the work of deleting, renaming, and relinking to the DBC. An additional benefit of this approach is that it uses ORDER BY so the table is physically ordered by the primary key of the table (if there is one). This speeds up access to the table in primary key order.

For more information on SDT (which does a *whole* lot more than just this), see www.stonefield.com.

Doug