|
Home > Archive > MS Access data conversion > April 2005 > Access Does Not Close
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Access Does Not Close
|
|
| David C 2005-04-06, 8:04 pm |
| 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 2005-04-06, 8:04 pm |
| Why? Probably because the sequence of events has gotten in your way. Why not
simply use DoCmd.Quit instead of .Close and Application.Quit?
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
"David C" <dlchase@lifetimeinc.com> wrote in message
news:u4DoMtsDFHA.3340@TK2MSFTNGP10.phx.gbl...
>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
>
| |
| David Developer 2005-04-06, 8:04 pm |
| 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" < ltrappNoSpam@ltcompu
terdesigns.com> wrote in message
news:ex1hZDuDFHA.512@TK2MSFTNGP15.phx.gbl...
> Why? Probably because the sequence of events has gotten in your way. Why
not
> simply use DoCmd.Quit instead of .Close and Application.Quit?
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
>
>
> "David C" <dlchase@lifetimeinc.com> wrote in message
> news:u4DoMtsDFHA.3340@TK2MSFTNGP10.phx.gbl...
It[color=darkred]
I[color=darkred]
in[color=darkred]
not[color=darkred]
>
>
| |
| Lynn Trapp 2005-04-06, 8:04 pm |
| 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.
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
"David Developer" <dlchase@lifetimeinc.com> wrote in message
news:OAU80cuDFHA.1936@TK2MSFTNGP14.phx.gbl...
> 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" < ltrappNoSpam@ltcompu
terdesigns.com> wrote in message
> news:ex1hZDuDFHA.512@TK2MSFTNGP15.phx.gbl...
> not
> It
> I
> in
> not
>
>
| |
| David C 2005-04-06, 8:04 pm |
| 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" < ltrappNoSpam@ltcompu
terdesigns.com> wrote in message
news:u5qGyluDFHA.4020@TK2MSFTNGP14.phx.gbl...
> 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.
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
>
>
> "David Developer" <dlchase@lifetimeinc.com> wrote in message
> news:OAU80cuDFHA.1936@TK2MSFTNGP14.phx.gbl...
>
>
| |
| Lynn Trapp 2005-04-06, 8:04 pm |
| 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?
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
"David C" <dlchase@lifetimeinc.com> wrote in message
news:e3GJOruDFHA.2180@TK2MSFTNGP12.phx.gbl...
>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" < ltrappNoSpam@ltcompu
terdesigns.com> wrote in message
> news:u5qGyluDFHA.4020@TK2MSFTNGP14.phx.gbl...
>
>
|
|
|
|
|