calling mdb from command line.

[gsd]

Hi,



I am trying to run the batch job from the command line. I created AutoExec macro in the mdb(msaccess 2007) which is calling someMainMethod() . How can I pass batch job id to the mdb?

Thank you....

Regards,

[June7]

Maybe these have clue
http://www.access-programmers.co.uk/...d.php?t=169203
http://support.microsoft.com/kb/209207

[gsd]

June 7,

Thank you so much. This helped me a lot.

But now I have one more issue. When I call the mdb file from command line as suggested by you, Access db is opened and stopped executing further.
I have to click on "Stop All Macros" --> then I have to select "Enable this content" in security alert options.

How can I get through these things?

Thanks & Regards,
Sri.

Maybe these have clue
http://www.access-programmers.co.uk/...d.php?t=169203
http://support.microsoft.com/kb/209207

[June7]

Do you already have Access set to allow macros to run without restriction? http://office.microsoft.com/en-us/of...001140307.aspx

[gsd]

Wonderful!! Thanks for the help, June7...

Do you already have Access set to allow macros to run without restriction? http://office.microsoft.com/en-us/of...001140307.aspx