>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,
Packing requires exclusive use of the table. This is not a good thing to do in a multiuser environment. Packing can be set up as an administrative utility that is run during off hours.
I use a recycling of deleted records to avoid packing. When the user wants to add a new record, first I look for a deleted record to reuse and if I find one I blank it out and recall it and then use that for the enw data. If there is no deleted record I append a new one.