I Need To Run A Macro When Database Open's + Closes ???

[StevenSkinner]

Hello,

Can someone Please Help

I need to Automatically run a macro when the MS Database(2000) Opens and When The Database Closes ???

Any Ideas ???

 

[Philem]

Hullo. You could try having the opening macro named AutoExec, as that will fire when the db opens. As for the closing macro, if you have your users only using forms, as you should, simply put a trigger for the macro in your Close button process. Users should NOT have the ability to simply X out of Access; they should be made to use a Close button you provide.

HTH
P