Access Stays in Memory

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JamesJ - 02 Dec 2007 22:07 GMT

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

Reply to this Message

boblarson - 02 Dec 2007 22:15 GMT

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.

Signature

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.

> After closing my AC 2007 database I found that Access 2007 is not removing
> itself from memory.
[quoted text clipped - 3 lines]
> Thanks,
> James

Reply to this Message

JamesJ - 02 Dec 2007 23:46 GMT

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

> 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
[quoted text clipped - 14 lines]
>> Thanks,
>> James

Reply to this Message