title: MS Access database (2010) how to create temporary table/procedure/view from Query Designer
body: <p>Is there any way how to create temporary table/view/stored procedure in MS Access database (2010) using Query Designer? </p>
  
  <p>Whenever i try to execute something like this:</p>
  
  <pre><code>SELECT * INTO #temp_table
  FROM (SELECT column_1, column_2 FROM table)
  </code></pre>
  
  <p>MS Access throws an error:</p>
  
  <blockquote>
    <p>Syntax error in CREATE TABLE statement.</p>
  </blockquote>
  
  <p>With no further information.</p>