title: Running Microsoft Access as a Scheduled Task
body: <p>I am seeking comments on how to schedule auto updates of a database (.accdb) since I am not very comfortable with the process I have set up.</p>
  
  <p>Currently, it works as follow:</p>
  
  <ol>
  <li>Task Scheduler calls a .bat</li>
  <li>.bat calls a .vbs</li>
  <li>.vbs opens the database and calls a macro</li>
  <li>The macro calls a function (VBA Level)</li>
  <li>The function calls the update Subroutine</li>
  </ol>
  
  <p>I consider there are too many steps and the fact that it requires 2 external files (.Bat and .vbs) related to the database and stored on the system increase the risk that the procedure would break.</p>
  
  <p>Apparently (but please tell me that I am wrong and how I can change it) .vbs cannot call a subroutine but only a macro. Identically, an access macro cannot call a subroutine but only a function if the user is expecting to enter the VB environment of the database. This is the reason why I called a function (VBA Level) that then calls the subroutine.</p>
  
  <p>Hope some of you know how to shorten the steps and eventually get ride of the .bat and .vbs</p>