-1

I would like to execute a vba module (backup module) at a specific day and time. Is this possible?

Sergey S.
  • 6,296
  • 1
  • 14
  • 29
Stjepan
  • 1

1 Answers1

1

The easiest way - schedule a task using Winsows Scheduler. In task you should start MSACCESS.EXE with full path to your accb file and /x MyMacro for starting a macro MyMacro, which should start backup process. For instance:

msaccess.exe "c:\MyFolder\MyDatabase.accdb" /x MyMacro
Sergey S.
  • 6,296
  • 1
  • 14
  • 29