msaccess.exe still in memory after access 2003 closed down

[simcon]

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.

 

[Wayne-I-M]

Hi Simcon

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

 

[simcon]

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

 

[Wayne-I-M]

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

 

[simcon]

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