Running macros automatically every day

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I have a cleanup macro that cleans up several databases
which I call clean. I use it everyday.

Is there a way in which the macro can run automatically
every day at a predetermined time without user input.

I already have a macro called autoexec which opens up a
master form which I would hate to rename.
 
Susan,

You can use Windows Task Manager, or another third-party scheduling
utility, to run the macro at the desired times. The command line
expression will be something like this...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\YourDB.mdb" /x clean
 
Back
Top