Solved shutdown function

[carlton]

Is there a function/macro I can write which will always be called when Access closes regardless of the method (except of course power failure/ windows crash).
I need to perform some specific clean up operation when the database closes regardless of whether the user presses the handy EXIT APP button.

 

[bob fitz]

Perhaps you could create a form which is opened but hidden when the db is opened. put you cleanup code in the forms close event.

 

[namliam]

You can use a hidden form that the user cant see or even your main menu and use the "On close" event to run your cleanup code.

Though the very need makes me wonder about the database

 

[CJ_London]

events are associated with forms or reports, so think the only way would be to have a hidden form and call your clean up operation in that form's close event

Edit: 3 responses at the same time at least same message in all of them....

 

[missinglinq]

A true photo-finish!

All bettors should retain their tickets while the track stewards review the photos!

 

[carlton]

You can use a hidden form that the user cant see or even your main menu and use the "On close" event to run your cleanup code.

Though the very need makes me wonder about the database

The database contains video attachments which must be written to the TEMP directory for displaying, this needs to be cleaned up.

 

[carlton]

Thanks, I'll test it out.