msaccess.exe still in memory after access 2003 closed down

[Guest]

sometimes when I clicked on an mdb file it wouldn't bring up Access. After
looking in Task Mananger I still had MSACCESS.EXE still running even though I
had shut the program down.

 

[Guest]

Hi Simcon

How are you closeing access - if you are using a button can you post the code.

 

[Guest]

just with the X box in top r/h corner of Window. I close it manually nothing
smart.

 

[Guest]

Just to check - try this

Create a button on a form (any form in the DB will do) and put this on the
OnClick event

Private Sub ButtonName_Click()
DoCmd.Quit
End Sub

Change the ButtonName to whatever you use

See if this closes the exe

 

[Guest]

Thanks Wayne will try it. The problem is intermittent if I go into Access and
come out immediately its fine and gets removed from memory. Its normally
after I have been doing development work. Running programs etc. Thanks for
your assistance will let you know.
regards,
Neil

 

[aaron.kempf]

Access MDB is a walking living breating memory leak

90% of the times i have a problem like this; it's because some idiot
used DAO and DAO hangs _ALL_ the time.

move everything to ADO and don't listen to the kids around here.

-Aaron

 

[James]

Hi

I get this problem too both with docmd.quit and via the top right 'X'.

Sometimes I even get a blank VBA window appear in what seems a random
timeframe (i.e. 30 mins after shutting access) that has the name of
the database I was using and then says with it 'No open projects'.
When I have this problem I can no longer double click a db in explorer
to open it but have to go through starting Access | File | Open etc.

Any ideas?

Regards
James