Carry out an action when my database first opens

  1. Create a macro containing the actions you want to run when you open the database.
  2. 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.