title: Change the default destination folder for Make Table queries in Access
body: <p>I inherited an Access db having many saved <em>Make Table queries</em> (MTQ). The problem is that they create the destination table in an external MDB, and the folder containing that external MDB may change depending on the environment.<br>
  All those saved MTQs have of course the destination db harcoded, with the full path:  </p>
  
  <pre><code>SELECT field1, field2 FROM tablex IN tblNew INTO 'X:\myfolder\myexternal.mdb'
  </code></pre>
  
  <p>Is there a way to <strong>modify the default destination folder</strong> of Access so that I could later change those MTQ into:  </p>
  
  <pre><code>SELECT field1, field2 FROM tablex IN tblNew INTO 'myexternal.mdb'
  </code></pre>
  
  <p>and have them automatically going to the appropriate folder ?<br>
  I tried using <code>ChDir</code> without success, and <code>CurrentProject.Path</code> is read only. Any other idea ?</p>