/x macroname

[John C.]

I'm trying to open a database and run a macro once the database is opened. I
am able to open the database using Microsoft Scheduler by typing in the path.

C:\mydatabase.mdb

When I try the /x command to run the macro, the database opens but does not
run the macro.

C:\mydatabase.mdb /x macroname

Am I doing something wrong?

 

[Dirk Goldgar]

I'm trying to open a database and run a macro once the database is opened.
I
am able to open the database using Microsoft Scheduler by typing in the
path.

C:\mydatabase.mdb

When I try the /x command to run the macro, the database opens but does
not
run the macro.

C:\mydatabase.mdb /x macroname

Am I doing something wrong?

You need to set the command line to execute msaccess.exe with the database
path and the /x argument on command line. Something like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Your
Path\YourDatabase.mdb" /x macroname

(Note: the above was entered all on one line, though it will dountless have
been wrapped onto two by the newsreader.)

Your path to Access will vary.

 

[john]

Thank You! Works great.

You need to set the command line to execute msaccess.exe with the database
path and the /x argument on command line. Something like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Your
Path\YourDatabase.mdb" /x macroname

(Note: the above was entered all on one line, though it will dountless have
been wrapped onto two by the newsreader.)

Your path to Access will vary.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)