I always thought that the record order was maintained, and didn't see evidence to the contrary - but perhaps the current index order is used, instead, as Jim suggests (if I understood his post correctly).

Try to SET ORDER TO, to make sure there is no index selected, and then PACK, and see what happens.

Or simply:

USE MyTable
PACK
USE

Since this is more or less the way I usually PACK tables (in some procedure which I run once a month or so), this might be the reason that I didn't notice a change in the record ordering.

>I hate to pack tables because after doing so the data is not in the order it was created. All my tables use a guid for the PK so I believe after they are packed they are in order by the guid.
>
>I know I could always set order to transactiondatetime (example) but when I just USE the table and then BROWSE it, I'd just like it to be in the same order it was in before the PACK.
>
>Is there a way?
>
>Thanks,
>John