title: Prevent MS Access Automatically Updating Queries
body: <p>Is there a way to prevent Access from updating a query, specifically removing a join, when a table no longer exists?</p>
  
  <p>For example, the following query is used with a temporary table;</p>
  
  <pre><code>Select Table1.Col1, Table1.Col2
  From   Table1 
    left join Table2 on Table1.Col1 = Table2.Col1
  Where  Table2.Col1 is null
  </code></pre>
  
  <p>If the temporary table is subsequently dropped and the query opened Access drops the join resulting in;</p>
  
  <pre><code>Select Table1.Col1, Table1.Col2
  From   Table1, Table2
  Where  Table2.Col1 is null
  </code></pre>
  
  <p>This is similar to to the question asked at <a href="https://stackoverflow.com/questions/1830856/prevent-access-from-changing-queries">Prevent Access from Changing Queries</a></p>