Having a macro run at scheduled times

  • Thread starter Thread starter RobertM
  • Start date Start date
R

RobertM

Hello:

Would anyone know how I would get a macro to run at
scheduled time intervals such as at 12:00 each night. I
have a backup macro that takes the data in each table and
exports to a text file for backup purposes. I have this
macro running whenever the database is closed. I'm finding
that this slows down closing the system and has caused
problems when two users close out at the same time.

Thank you

Robert
 
Create a Shortcut with Command line:

"PathToMSAccess.exe" "PathToMDBFile" /x MacroName

and use Windows Scheduler to run this shortcut at the
scheduled date/time.

If you want Access to close after, include Quit at the end
of your Macro.

Check Access Help topic "Startup Command-Line Options" for
different options in starting Access including the "/x "
option.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top