title: Dynamic SQL not returning results in Access pass-through query
body: <p>Consider the following code.</p>
  
  <pre><code>DECLARE @sql VARCHAR(MAX)
  SELECT @sql = 'SELECT * FROM caseinformation'
  EXEC(@sql)
  </code></pre>
  
  <p>When I run this in SSMS, it displays the same results as it would had I run <code>SELECT * FROM caseinformation</code>. But when I run this as an Access pass-through query, I get the following error message:  </p>
  
  <blockquote>
    <p>Pass-through query with ReturnsRecords property set to True did not return any records.  </p>
  </blockquote>
  
  <p>What gives?</p>