Can not shut down access

I

Ian Wallace

I have a large application under access, and up to
recently there have been no problems. Now when I try and
close my application the application closes but access
itself stays open and nothing I try will close it.
(Except to go into task manager.) Does anyone have any
ideas what may be wrong. (I have tried rebuilding,
reimporting, decompile, etc.)
 
V

Van T. Dinh

Do you mean the Access application window disappears but
Access is still in the memory?

How much memory is still shown as used by Access in the
Task Manager?

I had a case like that in AXP. A fellow developer used a
Calculated Control in a Subform in Continuous Form View.
Even though the instances of the Calculated Control showed
correct values for the "rows" (which I didn't expect), I
eventually found out that the Calculated Control was the
reason why MSAccess.exe remained in the memory.

If you have a similar arrangement, do the calculations in
the Query used as the recordSource for the Subform.

HTH
Van T. Dinh
MVP (Access)
 
Top