Question:
I have written an application that uses both DAO and OLE calls. This is a form-based application that sits on top of a CAD package. Sometimes when a user exits the application, the application stays resident in memory (for example, it shows up in the task manager). I am fairly sure that I am releasing all of my DAO and OLE objects. What might be causing the problem?
Answer:
Make sure that all forms are being unloaded, and that in the Unload event of the last form to be unloaded, you have the End statement. If you don’t End the application, you can get a phantom app with no windows that keeps running.