Why does msaccess.exe persist sometimes?

[Laurel]

Sometimes, after I close my database, and the job disappears from my tray, I
find that msaccess.exe is still running madly when I look in the Task
Manager. I've let it run for several minutes, but I've never seen it just
go away. One of the symptoms is that when I open Access again, it doesn't
finish opening the database. Another is that if I right-mouse/COPY the mdb
I'd been using, there's no "paste" in the right-mouse menu where I want to
move it.

This is not associated with bad closes.

 

[Ken Snell \(MVP\)]

Usually this is caused by a memory leak -- which occurs when you cause
ACCESS to create a reference to the database (or to ACCESS itself) and then
don't close that reference explicitly in the VBA code before you close your
application.

 

[Tony Toews [MVP]]

Sometimes, after I close my database, and the job disappears from my tray, I
find that msaccess.exe is still running madly when I look in the Task
Manager. I've let it run for several minutes, but I've never seen it just
go away. One of the symptoms is that when I open Access again, it doesn't
finish opening the database. Another is that if I right-mouse/COPY the mdb
I'd been using, there's no "paste" in the right-mouse menu where I want to
move it.

This is not associated with bad closes.

By bad closes you mean you've ensure that all your recordset opens
have closes?

There is also the check box issue which has been fixed, I think, in
some versions of Access.

Access minimizes to Windows 95/NT toolbar instead of closing
http://www.mvps.org/access/bugs/bugs0005.htm

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Laurel]

Ah, I'll check my code for recordset closes, as per the second response
here. Could you give me an example of what you mean by "a reference to the
database (or to access itself)," and the syntax for the associated close?
Perhaps you mean the instantiation of a recordset also?

 

[Ken Snell \(MVP\)]

Yes, my clumsy answer (typed while getting ready to rush out the door) was
meant to refer to anytime you do a "Set ObjectName = xxxx" code step in the
code, or when you create/open a recordset object, or other similar objects.