After closing database it will not open again - MSACCESS.EXE problem?

[redbase]

I have a problem in that when some users open certain forms within a database and use the forms, after they have closed the forms and exited the database they cannot open it again.

I have noticed that the MSACCESS.EXE process is still running. If I go into TASK MANAGER and PROCESSES and then END PROCESS on the MSACCESS.EXE I can then go in to the database and open the forms again.

Can anyone please suggest why this is happening and why the MSACCESS.EXE process does not stop automatically when exiting the database.

Thank you.

 

[RickSpr]

Usually, when Access won't terminate, it's because there are DAO objects that haven't been released. Access is waiting for a Recordset or Database object to be closed. In most cases, this happens automatically when the object goes out of scope, but there are certain exceptions.

Go through all your code that uses DAO objects and make sure you close each Database and each Recordset variable, and then set them to Nothing before exiting the procedure. You usually need error handling in such procedures to guarantee that the close happens even if an unexpected error occurs.

If that doesn't fix it, tell us whether you have created your own class modules.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[redbase]

Thank you for this information. I will check all of the code and post my progress.