>Mark,
>
>With your suggestion below Nadya can have absolute and full control over where this happens as she can create the new file whever she chooses and move it when she is done.

Jim,

Leaving aside the fact, that whole complicated code is already written based on ALTER TABLE, how can I do this process for DBC's tables?

>
>>Expanding on this 3rd option -- I guess you could create a new table with the revised structure that you need, and insert [or append] records into this table from the original table, close the tables, delete the original table, rename the new table to the original name. All this would be done in the default [startup] directory, so that is the directory where you would have to determine file space. Or you could create the new table on a another drive where you have enough disk space. Append from the old table if the field names have not changed, otherwise do INSERT SQL. Delete the old, copy the new to the original location with the original name as well.