I've never done exactly what you are doing ... but ... if I were in
Access, and if I ran the same query over and over, and if the query
adds new, temporary, records, then deletes the records (I know, this is
a lot of ifs) ... then, the solution would be to compact the database
(either from the toolbar ToolsDatabase UtilitiesCompact Database) or
from VBA. The only hitch with using VBA is that you can't write the
VBA code in the database that you want compacted. So, I write another
small database that has only one function in life ... to compact the
other database.

Sorry to bring Access stuff into this Excel environment, but it's the
only thing that came to mind that might fit your problem.


---
Message posted from http://www.ExcelForum.com/