title: Running VBA on Access via batch file (or similar file)
body: <p>I have a database provided to me externally. Unfortunately they've mistakely made a bunch of fields memo text rather than short text (fields I need to do JOINs on) and seem to have no intention of correcting their mistake (this is a UK government database after all). </p>
  
  <p>I've written some VBA to convert the many memo fields to short text.</p>
  
  <p>I will be getting new versions of this database all the time, so I can't store the conversion script in the database.</p>
  
  <p>To save a bit of time is there a way of running this vba script on the database using something like a .bat file? </p>
  
  <p>I know, for instance, that I can open Access 2013 via .bat using:</p>
  
  <pre><code>"C:\Program Files\Microsoft Office\Office15\MSACCESS.EXE" "C:\myfilepath\myfile.mdb"
  </code></pre>
  
  <p>But I can't find much info on whether scripts written in VBA can subsequently be run via .bat on the opened database (particularly if the script is not already written in to the database).</p>