How to prevent the AUTOEXEC macro from running when opening a database
Follow the instructions to prevent the AUTOEXEC macro from running when opening a database:
Select the ‘File’ menu and select ‘Open Database’.
Select the database location from the ‘Directories’ list box.
Select the database name from the ‘File Name’ list box.
Press and hold down ‘Shift’.
A good AutoExec macro can launch one or many different procedures or objects. In my view, the actions in the macro should either open a form or run a VBA function. Though a macro can do many things, it is recommended that you restrict this macro to simple tasks and leave complex tasks to VBA.