Windows Task Scheduler and Access macros

[EAB1977]

Hello everyone,

I am working on a project that automates a Excel report to our
managers using Access. I have researched on here about creating a
macro, creating a shortcut to a macro, then telling windows task
scheduler to run this macro at a predetermined time. It works great if
I am logged into the computer.

What I would prefer is while I am away from my PC, whether it is after
work hours or on the weekend, is to be able to run this macro. Can the
Windows Task Scheduler do this or is there a third-party solution that
I can try?

 

[Pasadena-D via AccessMonster.com]

I currently do this, but I have a 2nd computer that stays at work 24/7. There
are time when that computer was running, but I was not logged in as the
current user, and it still ran my macros. So if you leave your computer at
work and/or you have another computer at work that you can use to run the
macros then it will work. Hope this helps! The 2nd computer makes mine easy,
plus I can log onto that computer from anywhere and run programs from it just
like i was at work.

 

[Roger Carlson]

On my blog, I have a couple of posts that illustrate how to do this. How Do
I Run A Process Automatically Once A Day? Part I
(http://rogersaccessblog.blogspot.com/2008/10/access-101-how-do-i-run-process.html
) shows how to do it when Access is running. Part II
(http://rogersaccessblog.blogspot.com/2008/11/access-101-how-do-i-run-process.html)
uses the Windows Scheduler.

In either case, the PC has to be on.


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L