Problem with releasing access from memory

[Statistician]

Hi

I am experiencing problems with releasing a reference to access from memory. Basically I open up access from excel using vba code (dao), do some querying and then close the access application using the .quit and set = nothing commands.

However, an instance of access remains in memory (as viewed in task manager).

Can anyone offer some advice on how to remove the access application from memory? Any help is well appreciated!!

 

[FrustratedPgmr]

I had the same problem and I found that using the following on my Exit button worked.

Application.quit
Application = nothing

 

[TonyJollans]

Hi Statistician,

Are you sure you are closing everything and setting ALL the references you have to Access Objects (QueryDefs, RecordSets, etc.) to Nothing?

Enjoy,
Tony