running macros automatically

[Katie S]

I am able to use the task manager to open up the access database using:

"\\material_management_sharing\nodeissues(copy).mdb"

But from here I am not sure how i am suppose to get the macros to start
running with out going in and running them myself. In an answer to someone
elses question someone said that you do this like this:

"C:\PathToDB\MyDB/mdb" /x NameOfMacro

I could not get this to work for me, I just keep getting errors.
i dont understand how this is going to work without me typing it into the
task manager everytime.

Thanks for all the help.

Katie

 

[Wolfgang Kais]

Hello Katie.

I am able to use the task manager to open up the access database using:

"\\material_management_sharing\nodeissues(copy).mdb"

Why use the task manager?

But from here I am not sure how i am suppose to get the macros
to start running with out going in and running them myself.
In an answer to someone elses question someone said that you
do this like this: "C:\PathToDB\MyDB/mdb" /x NameOfMacro

I could not get this to work for me, I just keep getting errors.
i dont understand how this is going to work without me typing
it into the task manager everytime.

Create a new shortcut on your desktop. Click Browse and find the
executable msaccess.exe
(Usually "C:\Program Files\Microsoft Office\Office?\Msaccess.exe")
At the very end of that line, add (as someone said):
"C:\PathToDB\MyDB/mdb" /x NameOfMacro
(Separated from the "PathToMSAccess" by a blank)