>Jim,
>
> Thanks for that. Where is the best place to PACK? I don't want any records marked for deletion left in any tables upon exit, if I can see them or not doesn't matter. The size of the tables does matter.
>
>Eric K.
Eric, to PACK you will have to USE the table exclusively. In a multi-user program this could be a problem. Why not re-use any deleted records? I have a small function called "AddDel()" which checks for deleted records. If it finds one it is recalled, the data is blanked, and it is re-used. Otherwise the system issues an Append Blank or Insert depending on the situation (OK, folks, let's NOT start the Append/Insert controversy again :-) ).
If you have an index on Deleted() for each table this works very quickly.
HTH