Macro Scheduling

[Kankakee2006]

Is there a way to use scheduled tasks to run an Access macro hourly in the
background?

 

[Steve Schapel]

Kankakee,

Yes. The command line in your scheduler will be something like this:
"C:\Program Files\...<path to Access>...\Msaccess.exe"
"C:\YourFolder\YourApp.mdb" /x NameOfMacro

--
Steve Schapel, Microsoft Access MVP

Is there a way to use scheduled tasks to run an Access macro hourly in the
background?

__________ Information from ESET Smart Security, version of virus signature database 4174 (20090620) __________

The message was checked by ESET Smart Security.

http://www.eset.com