Possible Reasons for Access not completly closing

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

When I exit my application I can open task manager and see Access is still
running under the processes tab. This doesn't happen all the time and
sometimes there are multiple instances running in processes. What would
cause this and are there ways to trace or correct the problem.
 
Usually that results from running code that does not destroy created objects
that refer to items within the ACCESS database. The ACCESS application will
not close until those objects are destroyed.

You'll need to look through your code and find places where you create an
object (e.g., Set VariableName = New objectname; Set VariableName =
CurrentDb; etc.) and then don't destroy it by closing it and then setting it
to Nothing.
 
Back
Top