Passing parameters from command line

G

Guest

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 odbc parameters via the command line 1
parameter value in command line switch 4
passing parameters between combo boxes access 2007 2
Command button VB code 9
Too few parameters error with a IIF statement 5
Passing command line parameters between instances 2
Passing several parameters to OnAction property. 1

Top