Running Macros Automatically -- Possible?

[Myriad_Rocker]

Hey everyone!

I have some tables that I am updating from DB2 that I have linked in Access. I run macros to get those to update and all that and the tables are then used for various things.

My question is, is it possible to schedule a macro to run say, Saturday's at midnight? I would like the process to run automatically so no one would have to go out and run that macro manually at some point during the week.

 

[jfgambit]

Yes...Use Windows Schedule Task to create a new Task, in the RUN field add the following:

Path to database \x NameofMacro:

Example:

C:\Access\AuctionDb.mdb /x UpdateMacro

 

[Myriad_Rocker]

Okay. If I may, I'd like to pose a few more questions...

If I am technically signed on to my computer but the machine has been "locked"....would the scheduler still run.

What if I am logged off of the network....would it still run?

It's obvious that it wouldn't if my machine was turned off but I'm assuming that it would run right when my machine was booted up.

 

[jfgambit]

Yes...I run nightly updates and the machine is "locked"

No...I do not believe they will run if you are not logged onto the system.

HTH

 

[Myriad_Rocker]

Well...that got blown out the window. Our client services dept won't allow for Task Scheduler on the machines.

Any work arounds?