Scheduling/Automating Access Code

  • Thread starter Thread starter JohnV
  • Start date Start date
J

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
 
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
 
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 create a macro, and use Scheduled Task with /X command
line, i.e,

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

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


Tim F
 
Back
Top