Jim,
I would like to take credit but it was Garrett's suggestion to use ALTER TABLE. :)
>I sent through a change request to the article to use Sergey's algorithm of
>
>alter table ... add column ...
>alter table ... drop column ...
>
>rather than pack. I like it better, you don't have to worry about losing deleted records if you want to retain them for some reason, and it works even if there are no deleted records.
>
>I also had them add info about error 2065 to the article.
>
>Thanks!
>
--sb--