How to Clear Memory in Access

[aa2002]

Is there a way to clear the memory in Access without quitting the application. I am running a large database with complex reports and it seems to be not reallocating the memory after I close the report. Any suggestion would be greatly appreciated.
Thanks

 

[Stickarm]

Are you using Temp Tables?

Phil

 

[aa2002]

Yes I am, but I clear them out after use.

 

[Stickarm]

It doesn't matter with tables, they are the ones that don't reallocate space... If you compact the database it will do it. If there is a way to run the reports without the temp tables. the database size shouldn't change.

 

[WildHare]

Also, be sure you null out any temporary database objects that you might create - which will, I believe, also release their "malloc()s"

Set db = ???
set rst = db.????
...
...
...

set db = NOTHING < the actual word &quot;nothing&quot;
set rst = NOTHING < the actual word &quot;nothing&quot;

I think the general rule I've seen people use is to set to NOTHING any object that you use SET... with to enable.




78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

http://www.jmhare.com