Passing parameters from command line

S

Shah

In a program I can start other programs, sych as ACCESS, by using command line paramters. I need to pass a name to be fed into a macro of ACCESS

I have got as far as
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS11.EXE" "C:\mydatabase.mdb" /x mymacr

This will start Access and open mydatabase and run mymacr
BUT it will open a new session every time and I can not pass on the parameters which the macro wants

Can you please let me know how open a new session of ACCESS only if it is not already openned and to pass the parameter to the session in either case

Many thanks and regards
Sha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Line Switch in a hyperlink? 4
Passing CMD value through Outlook hyperlink 0
Stopping or Restarting an Access App From Command Line 2
parameter value in command line switch 4
Passing parameters from DOS shell to a word macro 1
passing parameters between combo boxes access 2007 1
passing odbc parameters via the command line 1
passing values from access to excel 1

Top