>>>>>No matter what I do, I can't get a small table with 80 odd records in to pack. I can delete the records, but no way will it pack, no matter what SAFETY is set to, or even if used EXCL.
>>>>>
>>>>>A timer runs every few minutes, zaps the file, and gets updated data put into it for a grid. Eventually the file is soooo stuffed full of stuff that it takes ages to put new stuff in. It is ridiculous to think of the user having to go and clear it manually.
>>>>>
>>>>>Any ideas? Thanks.
>>>>
>>>>a couple stupid questions -- is the table in question listed as an item within the project? Is it tagged as excluded?
>>>>
>>>>(yes, I'm aware that if the file is included in the EXE, trying to DELETE a record should throw an error -- but I'd run into occasions where an error trap masked this)
>>>
>>>I bet he's zapping/packing one table and looking at another
>>>
>>>This whole thread makes no sense - at all
>>
>>as OP code does not force the bookings table to be the active table, I certainly won't bet against you ;-))
>
>I think this is the only possibility left
>
>I've never ever seen a pack that does not pack without giving an error

the code does a use in 0, no select afterwards and no "in" with delete, pack or zap. If ANY table is active before that snippet... and no attempt to show current alias/dbf in the messageboxes