Scheduling/Automating Access Code

[JohnV]

I have some code that I periodically run throughout the
day. Does anyone know a way to get the code to run
automatically or at a specified time?

Thanks,
JohnV

 

[Lucky]

If it is within the db, use On Timer event or you can use
Scheduled Task (in My Computer folder) and create AutoExec
macro to run your code (under RunCode) if you have no
forms in your db.

Lucky

 

[Paul Overway]

Or you can create a macro, and use Scheduled Task with /X command line, i.e,

"path to msaccess.exe" "path to your.mdb" /x yourmacroname here

 

[Tim Ferguson]

Or you can create a macro, and use Scheduled Task with /X command
line, i.e,

"path to msaccess.exe" "path to your.mdb" /x yourmacroname here

Or you can just do the thing in a vbs file, which you can run direct from
the scheduler...


Tim F