Exit error

[Gary D.]

I have just converted an Access 97 mdb to Access 2003.

In my application I have a MainMenu form (using a modified switchboard).
The form has an Exit button to quit Access.
It uses the code;
Application.Quit acQuitPrompt (was Application.Quit acSaveYes in Access 97)

This always used to work just fine and apart from changing the option
"acSaveYes " to "acQuitPrompt " I have not changed anything else in the code.

However, when I click the Exit button I now get Error 91 (object not set...
etc.).

I have also tried changing Application.Quit acQuitPrompt to Dcmd.Quit but I
still get Error 91.

When the error occurs I cannot see the code to debug it because the database
does close down and exit, so it would appear to be working successfully.

Any ideas what might be causing this Error 91 problem?

 

[Van T. Dinh]

Since the exiting the database and quitting Access will trigger other
Events, you may need to trace the code and see what triggers the error. See
also the following article which may / may not be applicable to you:

http://support.microsoft.com/?id=287485

 

[Bret Reid Jones]

bret