Create a macro that runs when an Access file first opens
- Create a macro containing the actions you want to run when you open the database.
- Save the macro with the name AutoExec.
The next time you open the database, Microsoft Access runs this macro automatically.
Note If you don't want to run the AutoExec macro when you open the database, hold down the SHIFT key when the database opens.