Using Scheduled Tasks to run Macros problem

[Andy]

I have a database with two macros in it. When i run these macros from within
the database, they run fine and when I run the shortcuts to the macros it
runs fine.

However, whenever I try to run the macro via Scheduled Tasks they frequently
fail and I get error messages with regards to docmd scripts, OLE errors etc.
Is there any reason why something would run OK normally, but not via a
Scheduled Task that I should be aware of? I can give more specific error
message details and VBA if it would help.

Thanks

 

[Arvin Meyer [MVP]]

There may be a permissions problem. Try setting up the tasks to run as an
administrator.

 

[Douglas J. Steele]

And depending on what version of Access you're using, make sure that Macro
security is set up properly on the machine on which the task is running (for
Access 2003, see
http://www.accessmvp.com/JConrad/accessjunkie/macrosecurity.html for
details) or that the database is located in a Trusted Location (for Access
2007)