Task Scheduler vs. Access

[Guest]

Right now, I've got some Access macros scheduled using the Windows Task
Scheduler. The databases are on a shared drive and the Task Scheduler is set
on a PC that is supposed to never be turned off.

Just wondering if anybody has ever been successful at scheduling a macro in
a database that is on a shared drive without being dependant on any PCs? I
guess, I should ask, is there a way for an Access database to open itself?

For example, if I have VBA code that checks the current time and day to do
something, is there a way around having to kick off that VBA code using a
powered-on PC?

 

[Norman Yuan]

Now you talking VBA code, it is code inside an application, namely, inside
your MS Access application. If you want to code to do something, the
application where the code lives in must be running. So, the MS Access
application is not running, it cannot open itself ("it" does not exist!).
That is where Task Scheduler plays the role.