Hi,

I'm running a query on my excel application and I have a strange problem:
after running the query several times (the datas are on a sheet of the same
excel file) I got this error : "Insufficient Memory" and then : "Runtime
Error 7 - Insufficient Memory".
Moreover, this error comes out not on all the PCs that are running the
application..
For example on a Win 2000 Pro and Office 2000 Standard I got the problem,
but with a Win NT and Office 2000 Standard the problem does not occours...
I've noticed that on the PCs where I got the problem, everytime I run the
query the memory usage raises and goes higher and higher, instead on the
other PC the memory temporanely raises when I launch the query, but then it
returns to the original value..

Any ideas?

Thanx all

Luca.

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/