I have a database recently ported from Access 2.0, now running in Access 2003
under Windows XP.
It is driven from a form with a number of buttons on it.
One of these is "Quit Access", with the code Application.Quit acQuitSaveNone.
Another is "Close database", with the code Application.CloseCurrentDatabase.

Both succeed in closing the database, but often Access stays open. Access
is then impossible to close without killing the task via the Task Manager.

Can anyone suggest what's going on here?

Access will not close if some object is not releasing memory.

There could be many places to look for a problem of this kind. You need to
explicitly close everything you open, set your objects to Nothing, and
de-instantiate any classes you create. For example, if you OpenRecordset in
code, you need to close it again with:
rs.Close
Set rs = Nothing
and you need to ensure that this code executes even an error handler changes
the flow of the procedure.

It would also be worth repairing the database, such as the steps for the
first symptom in this article:
http://allenbrowne.com/ser-47.html


--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Stephen Bull" <(E-Mail Removed)> wrote in message
news:4A919DC8-CE7F-4E9A-A7FD-(E-Mail Removed)...
>I have a database recently ported from Access 2.0, now running in Access
>2003
> under Windows XP.
> It is driven from a form with a number of buttons on it.
> One of these is "Quit Access", with the code Application.Quit
> acQuitSaveNone.
> Another is "Close database", with the code
> Application.CloseCurrentDatabase.
>
> Both succeed in closing the database, but often Access stays open. Access
> is then impossible to close without killing the task via the Task Manager.
>
> Can anyone suggest what's going on here?

You need to look for code like
If chkBox then

and change it to
If chkBox = true then

(david)

"Stephen Bull" <(E-Mail Removed)> wrote in message
news:4A919DC8-CE7F-4E9A-A7FD-(E-Mail Removed)...
>I have a database recently ported from Access 2.0, now running in Access
>2003
> under Windows XP.
> It is driven from a form with a number of buttons on it.
> One of these is "Quit Access", with the code Application.Quit
> acQuitSaveNone.
> Another is "Close database", with the code
> Application.CloseCurrentDatabase.
>
> Both succeed in closing the database, but often Access stays open. Access
> is then impossible to close without killing the task via the Task Manager.
>
> Can anyone suggest what's going on here?