title: Run Query Against ODBC Connected Table VBA
body: <p>I have a table (readings) already connected by ODBC in Access that opens very quickly when I click on it.  </p>
  
  <p>However, when I try to run this in VBA I it locks up and never displays anything:</p>
  
  <pre><code>Dim strSql As String
  strSql = "SELECT readings.ids " &amp; _
           "INTO ids_temp " &amp; _
           "FROM readings " &amp; _
           "WHERE readings.ids &gt; 1234;"  //This is id in middle of list
  DoCmd.SetWarnings False
  DoCmd.RunSQL strSql
  DoCmd.SetWarnings True
  </code></pre>
  
  <p>For some reason this crashes the whole system. Any ideas?</p>