autorun macro

P

Pablo

How do I set up a macro or procedure that will automatically update
information into a table, and have it run at a scheduled time?

My database is stored on a network, so I would like for this procedure to
happen automatically without human intervention.

Thanks,

Pablo
 
S

Steve Schapel

Pable,

You can create your macro to do this task, probably by using an
OpenQuery action to run an Update Query.

Then, use Windows Task Manager, or some other scheduling utility, to run
it. The Command Line of the scheduler will look something along these
lines:
"C:\Program Files\...\Msaccess.exe" "F:\YourFolder\YourDb.mdb" /x
NameOfMacro
 
P

Pablo

Steve,

It worked! Thanks a lot,

pablo

Steve Schapel said:
Pable,

You can create your macro to do this task, probably by using an
OpenQuery action to run an Update Query.

Then, use Windows Task Manager, or some other scheduling utility, to run
it. The Command Line of the scheduler will look something along these
lines:
"C:\Program Files\...\Msaccess.exe" "F:\YourFolder\YourDb.mdb" /x
NameOfMacro
Click to expand...
 
A

Amod

Pablo,
I also have a similar situation where I want have created a macro to
openQuery & my DB resides on network. Can you please tell me how you created
a autorun for this macro. I will really appreciate if you can reply me back
at: [email protected]

Thanks in advance.
 
A

Amod

Pablo,
I also have a similar situation where I want have created a macro to
openQuery & my DB resides on network. Can you please tell me how you created
a autorun for this macro. I will really appreciate if you can reply me back
at: [email protected]

Thanks in advance.
 
Top