Opening database from command-line

[Karl]

I am trying to open a database and run some code from the
run option on Windows startup menu. I have a macro
(mcrRoamers) which uses the runcode option to run the
code. This code then filters a report and outputs it in
pdf format. The command line argument I am using is:

c:\fsdata\oracle\oracle.mdb /x McrRoamers

where oracle.mdb is the name of the database and
mcrroamers is the macro which runs a function.
The database is opening but the macro is not starting. I
can't use the autoexec macro as this is only one of five
reports that have to be started at random times from the
command-line, so each has to have its own macro.

Any ideas why this would not be starting off the macro
would be appreciated.

Regards
Karl

 

[Joan Wild]

When using a switch, you must provide the full path to msaccess.exe, for
example:
"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"c:\fsdata\oracle......

 

[Guest]

Thanks Joan

-----Original Message-----
When using a switch, you must provide the full path to msaccess.exe, for
example:
"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"c:\fsdata\oracle......

--
Joan Wild
Microsoft Access MVP




.