autorun macro

  • Thread starter Thread starter Pablo
  • Start date Start date
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
 
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
 
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...
 
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: (e-mail address removed)

Thanks in advance.
 
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: (e-mail address removed)

Thanks in advance.
 
Back
Top