/x macro function 1

[tma12000]

I am looking to run a macro from a command line. But whenever it runs, it opens the db and simply highlights the macro I want to run, without actually running it. WHat am I doing wrong?

D:\path\dbname.mdb /x macroname

Thanks,
Tim

 

[tma12000]

I should add... I do have things running in AutoExec... would that interfere with it?

 

[GoDawgs]

Why not run the second macro from inside the AutoExec macro?

 

[tma12000]

The macro sends information over a network to another db. I have users who log into the db remotely that do not have access to the destination directory, so if it is in Autoexec, the macro fails.

Thanks,
Tim

 

[PaulBricker]

What is the command line you are using and what are the actions in the macro.

Paul

 

[CosmoKramer]

Tim,

Try adding the path of the Access .exe to your command line. Something like:

"C:\Program Files\Microsoft Office\Office\MSAccess.exe" D:\path\dbname.mdb /x macroname

I use this syntax in a DOS batch file, but it should work in a shortcut too....

Hoc nomen meum verum non est.

 

[tma12000]

The command line is
D:\path\dbname.mdb /x macroname

The macro is pulling data from a db that exists over a network.

 

[GoDawgs]

Did you try CosmoKramer's post?

 

[tma12000]

It appears it did... thank you guys so much for your help!

Tim