Quitting Application won't close Access 7.0 
Author Message
 Quitting Application won't close Access 7.0

Liz:

How are you exiting the app? If you have a push-button run a macro with the
Exit action it should shut down Access completely.

        -- Wesley



Quote:
> I have a database ready for distribution except for the one extremely
> annoying fact that on quitting the application Access stays in the task
> bar.  I have checked that all recordsets and databases have been closed
but
> still no luck.  Can any one help, I'm getting desperate for a solution.

> Liz



Mon, 03 Apr 2000 03:00:00 GMT  
 Quitting Application won't close Access 7.0

I have a database ready for distribution except for the one extremely
annoying fact that on quitting the application Access stays in the task
bar.  I have checked that all recordsets and databases have been closed but
still no luck.  Can any one help, I'm getting desperate for a solution.

Liz



Mon, 03 Apr 2000 03:00:00 GMT  
 Quitting Application won't close Access 7.0

Hi Liz,

It seems that Access stands alone even after an Application.Quit when at
many conditions are present: eliminating one of these conditions and Access
will shut down.

The easiest condition in your control is to set any global reference of
object to Nothing. As example, if you have globaly defined

Pblic Db As Database

then, before exiting, you must also write:

Set Db = Nothing

So, check carefully all your global declarations and if one contain an
object ( anything that must be "Set"), assign it to Nothing before closing.

(That condition alone is not enough to REPRODUCE the Access behavior you
have observed, as demonstrated by this code in a module:

Public Db As Database

Public Sub CloseAccess()
    Set Db=CurrentDb()
    Application.Quit
End Sub

Running CloseAccess will effectively close Access, even if Db is not set to
nothing, ... just to show that other conditions have to been met to
reproduce the behavior...)

Hope it may help,
Vanderghast, Access MV^P.

Quote:

>I have a database ready for distribution except for the one extremely
>annoying fact that on quitting the application Access stays in the task
>bar.  I have checked that all recordsets and databases have been closed but
>still no luck.  Can any one help, I'm getting desperate for a solution.

>Liz



Tue, 04 Apr 2000 03:00:00 GMT  
 Quitting Application won't close Access 7.0

Hi Liz
        Don't know if yours is the same problem but I have had a
database perform a similar feat myself. Every time I went to shut the
thing down It just minimised itself down to the task bar. The only way
that I could shut it down was to right Click on the minimised Access and
select close from there. Is this the same problem ??. If so let me know
beacause there are also another couple of bizzare happenings that
accompanied this.



Quote:
>I have a database ready for distribution except for the one extremely
>annoying fact that on quitting the application Access stays in the task
>bar.  I have checked that all recordsets and databases have been closed but
>still no luck.  Can any one help, I'm getting desperate for a solution.

>Liz

--
Barry Cowles


Wed, 05 Apr 2000 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. HELP NEEDED: Access 95 DAO Error - Won't Start, Access Quits

2. Help - Access Still Won't Quit!!!

3. Access 97 Won't Quit even after environment cleaned up

4. Can't quit Access - Table not closed

5. Access Won't Quit?

6. Help - Access Still Won't Quit!!!

7. Access '97 won't close

8. Application won't close

9. Application written for Access 2000 with DAO won't run in Access 2002

10. Access won't close after 'application.close'

11. Access won't close

12. Access won't close

 

 
Powered by phpBB® Forum Software