Access Stays in Memory

  • Thread starter Thread starter JamesJ
  • Start date Start date
J

JamesJ

After closing my AC 2007 database I found that Access 2007 is not removing
itself from memory.
I need to go to Task Manager and end the task manually.
Is there a fix for this??

Thanks,
James
 
It sounds like you might have some code that didn't get properly "garbage
collected." Is there anywhere where you used code for something like
DBEngine or CurrentDb?

Also, if you used code for Excel or Word within your Access database, didn't
use explicit references when coding (using ActiveCell = xxx instead of
xlWS.ActiveCell, etc) and you still have a worksheet or document open, it
could hold Access open.

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
 
No code like that.
Just had another thought. I noticed Access open when I attempted to open a
db from Explorer. For some reason after double clicking the db nothing
happens.
I think that's when Access goes in memory but doesn't open the db
for some reason. After ending the task and trying again it opens fine.
Checked after closing this time and Access did close.

James
 
Back
Top