Can not shut down access

[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.)

 

[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)