Autoexec opposite...

[QUINABA]

Hello,

Is there such a thing as an Autoexec opposite, that would perform macros on exit? I'd like to delete some temporary tables that I've created upon exiting.

Any help would be greatly appreciated.

Thanks.

 

[Cbrine]

I believe that you can create a macro called

Autoexit

that executes on close of the database.

 

[QUINABA]

Thanks for the response but it didn't work (I'm using Access 97). Any other ideas?

 

[QUINABA]

Bump...

 

[CT Witter]

I have used two solutions in the past.

1) Have a main form that opens when the database starts(ie Switchboard). On this form have a button which has the action Application.Quit to quit access. Then on the form's OnClose event run your code to clean-up.

2) The other comes from MS KB article # 210297 - Detect User Idle Time or Inactivity in Access 2000. This event opens a hidden form that runs in the background. In this case it checks to see if the user has been inactive and closes the db after a threshold has been reached.

You could modify and add in your table cleanup code before the database is closed. Also, you could again implement the Onclose Event to clean-up.

I like this approach as you will get the added benefit of having users out of the db when they aren't using it. In addition, the form is hidden so you won't have users messing with it.

HTH,
CT

 

[Dugantrain]

It should also be noted that running procedures during an application's quitting is considered bad practice as these procedure's wouldn't trigger during, say, a power failure, or the dreaded Ctl-Alt-Del and you could really do some damamge to your data/objects. A work-around to this is to either find a way to incorporate your procedures while the db is open or to have your procedures trigger during the On Open event of the database/Startup form.