Link to home
Start Free TrialLog in
Avatar of Richard Korts
Richard KortsFlag for United States of America

asked on

MS Access "Auto Exec"

I know there is a way to run a macro (or query) automatically when an Access database is opened.

I know there is a way to open an Access DB with an Auto Exec Macro and NOT execute the macro; I can't remember how?

How can I edit the Auto Exec Marco to change what it does?

Thanks
SOLUTION
Avatar of Gottler
Gottler

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Bembi
Bembi
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
to bypass the macro or automatic opening of the "Display Form" (the form that is automatically opened at startup, which is set in the Access Options -> Current database), hold down the shift key as the database opens.
Avatar of Richard Korts

ASKER

If there is an AutoExec Marco, is iit called "AutoExec" or something like that?

Thanks
If it is an AutoExec Macro (and not auto statup form) then there is should be one, yes...
Another article for you.:
http://support.microsoft.com/kb/826765
"I know there is a way to run a macro (or query) automatically when an Access database is opened."

It's a macro you create to do whatever - with a very specific name:
AutoExec

User generated image
"I know there is a way to open an Access DB with an Auto Exec Macro and NOT execute the macro; I can't remember how?"

When you open the database, hold down the Shift key - until the db is completely opened. This will bypass the AutoExec macro (and/or any start up Form - as mentioned by fyed).  You will now able to edit the AutoExec macro.

Note that ... if this is not your db. it's possible that the Shift Key bypass has been removed, which then requires additional steps to get into the db.

mx