Access exe stays in Task Manager after quit

[tbclbd]

I'm working in Access 2003, and have a database in the 2000 format. If I open the database, stay on the main form and exit, access is released from the task manager. If I open any other form from the main form, when I exit, access.exe stays in the task manager. I've gone through the database and checked that each time a recordset was open, it was closed and released. I added a routine upon close which loops through and looks for any forms that are still open, and unloads them. does anyone have any other suggestions of what I should be looking for? Thanks

 

[AndyInNC]

I hate those kind of hidden, intermittent problems. They are so hard to troubleshoot!

Here are some thoughts:
Does it happen with other MDBs? If so, maybe Access is corrupted and needs to be reinstalled. (Check 3 or 4 databases.)

Try compacting & repairing the MDB. (Back up the original first.)

Inside the code, make sure all the objects are released before exiting each Sub or Function. I.e. Set MyObject = Nothing

Finally, I would start with a new MDB and import the objects and code one piece at a time to try to isolate an offending problem.

Good luck!