Some users have reported that when they close down a particular Access application the Access database closes but the Access application stays open but minimises to the system tray.
The only way to stop the Access application is to kill the application from Task manager.
After a bit of testing I think the problem occurs when the user exports a report to Word using the following code:
DoCmd.OpenReport sRptName, acViewPreview
DoCmd.RunCommand acCmdOutputToRTF
DoCmd.Close acReport, sRptName
I am guessing that Access is retaining a memory reference to the Word object it creates when exporting the report or somehting lie that. The problem is, as I am not creating the Word document in code but relying on the build in export funtionality, how can I get Acces to release all it references to external objects (if that is the problem).
Even stranger, it only happens for some people, not everyone.
Any one with any ideas?
.phil
The only way to stop the Access application is to kill the application from Task manager.
After a bit of testing I think the problem occurs when the user exports a report to Word using the following code:
DoCmd.OpenReport sRptName, acViewPreview
DoCmd.RunCommand acCmdOutputToRTF
DoCmd.Close acReport, sRptName
I am guessing that Access is retaining a memory reference to the Word object it creates when exporting the report or somehting lie that. The problem is, as I am not creating the Word document in code but relying on the build in export funtionality, how can I get Acces to release all it references to external objects (if that is the problem).
Even stranger, it only happens for some people, not everyone.
Any one with any ideas?
.phil
