Open DB without triggering autoexec macro

[OhioSteve]

I have an autoexec macro in an .mdb. To open the db without triggering autoexec, I must hold down the shift key. I have a windows shortcut to this .mdb. Can I put something in the "target" part of that shortcut, that would stop autoexec.

 

[fkegley]

It would be simpler to rename the AutoExec macro.

Frank kegley

 

[rubbernilly]

I agree. Rename the autoexec macro to something, then use the "/x macroname" parameter to the launch of Access anytime you want to run the new autoexec. Open it without the macro whenever you do not want to run that macro.

 

[OhioSteve]

I tried renaming the macro to autoexec1. Then I set the target to "C:\ /autoexec1 db1.mdb". Unfortunately, the shortcut stopped working then. So I tried "/autoexec1 C:\db1.mdb". Windows would not allow that name.

 

[pedrox]

Setting the target to
c:\db1.mdb /xautoexec1
may do the trick for you

 

[rubbernilly]

I think you need a space after the /x...

"c:\program files\Microsoft Office\Office\MSACCESS.EXE" "c:\db1.mdb" /x autoexec1

HTH