autorun macro

[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

 

[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

 

[Pablo]

Steve,

It worked! Thanks a lot,

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

 

[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: (e-mail address removed)

Thanks in advance.

 

[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: (e-mail address removed)

Thanks in advance.