Access Does Not Close

[David C]

I have an Access 2003 application that was converted from Access 2000. It
has ODBC connections (linked tables) to SQL Server 2000. Sometimes, when I
close the application from the main startup screen, using DoCmd.Close of the
form, followed by an Application.Quit the MSACCESS.EXE stays running in the
Task Manager. If I try to start the same application again it does not
display, unless I stop the process in Task Manager and start it again.
Anyone know why this is happening?

David

 

[Lynn Trapp]

Why? Probably because the sequence of events has gotten in your way. Why not
simply use DoCmd.Quit instead of .Close and Application.Quit?

 

[David Developer]

Well....because Microsoft recommends the Application.Quit instead of
DoCmd.Quit, according to the help file and everything I have read. Hmmmmm.
David

 

[Lynn Trapp]

Hmmmmmmmmmmmm... is right. If you create quit button using the button wizard
it will write DoCmd.Quit. You can also simply use Application.Quit without
using the DoCmd.Close method.

 

[David C]

A new wrinkle. I tried your suggestion and MSACCESS.EXE still does not
unload and still shows in Task Manager, not in Application tab, but in
Processes tab ?????? And....The LDB file goes away.

I even tried re-install of Office 2003 and it still does it. Any other
ideas?

David

 

[Lynn Trapp]

Have you created some object in code that you are not closing. For instance,
do you, somewhere, create a recordset and not set it to Nothing?