Re: Why does msaccess.exe persist sometimes?

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.
--

Ken Snell
<MS ACCESS MVP>


"Laurel" <FakeMail@xxxxxxxxxxx> wrote in message
news:ereBgYA8HHA.1204@xxxxxxxxxxxxxxxxxxxxxxx
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)" <kthsneisllis9@xxxxxxxxxxxxxxxxxx> wrote in message
news:unNUb%2317HHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
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.

--

Ken Snell
<MS ACCESS MVP>


"Laurel" <FakeMail@xxxxxxxxxxx> wrote in message
news:umTJL717HHA.5980@xxxxxxxxxxxxxxxxxxxxxxx
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.







.

Relevant Pages

  • Re: Late Binding for DAO
    ... If the runtime was created from a database that had the DAO reference set, ... >> <MS ACCESS MVP> ...
    (microsoft.public.access.formscoding)
  • Re: command buttons not responding
    ... installing SP3? ... working with a corrupted database, ... MS Access MVP ... I've checked that the reference to the on-click procedure is ...
    (microsoft.public.access.forms)
  • Re: DH - Query By Form
    ... MS Access MVP ... "tbd" wrote in message ... > plonker about it, I was in the tools menu in the Database, ... I am asked for a reference ...
    (microsoft.public.access.queries)
  • Re: Making a combo box change a combo box
    ... Doug Steele, Microsoft Access MVP ... I am putting a database for a music instrument company. ... I would like to make the 2nd box reference a table related to the 1st ...
    (microsoft.public.access.forms)
  • Re: New Error in modules
    ... > I have a database that I have been using for about a year. ... reference, and re-checking it. ... if you're using Access 97, it would be the DAO 3.51 Object ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.modulesdaovba)