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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top