command line issues running a marco

[dman]

Hi.

Is there a way around an additional prompt when I open my db/macro
from a command line?

"C:\Program Files\Microsoft Office\Office11\MSAccess.exe" "C:\Path\My.mdb"
/x My_Marco

I am trying to schedule this marco as a task, however, before the db fully
opens, I get a security warning
prompt that tells me this file may not be safe, etc, and I have to click
'OK" to open. This prevents
the task from running because the db never opens...just sits at the prompt.

Is there a parm that can override this security question?

Thanks!

 

['69 Camaro]

Hi.

I am trying to schedule this marco as a task, however, before the db fully
opens, I get a security warning
prompt that tells me this file may not be safe, etc, and I have to click
'OK" to open.

Either set Macro Security to low or sign the database application with a
digital certificate.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[dman]

Thank you.

Setting the Marco Security to low removed the warning prompt.

D

 

['69 Camaro]

You're welcome. Glad it helped.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.