title: Script to open Access database, run macro, and persist Access instance
body: <p>I would like to have a script to:</p>
  
  <ol>
  <li>Open an Access .accdb file</li>
  <li>Run a macro within the database</li>
  <li>Leave this open</li>
  </ol>
  
  <p>I can very easily do the first two with the following VB script:</p>
  
  <pre><code>dim accessApp
  set accessApp = createObject("Access.Application")
  accessApp.visible = true
  accessApp.OpenCurrentDataBase("C:\path.accdb")
  accessApp.Run "myLinker"
  </code></pre>
  
  <p>But it immediately closes the Access database when the VBS execution finishes. I would like the instance to remain open independent of the script.</p>
  
  <p>I am not forced to use VBScript for this but it definitely seems the easiest to actually invoke the macro to run.</p>