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
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