title: Access union all into new table
body: <p>I have a saved query (MyUnion) for a union, appending monthly files (linked views):</p>
  
  <pre><code>select * from RawTrade1801
  union all
  select * from RawTrade1802
  </code></pre>
  
  <p>Trying to write this to a new table is proving problematic:</p>
  
  <pre><code>SELECT MyUnion.* into RawTrade2
  FROM MyUnion
  WHERE Field8 = 'ZAR';
  </code></pre>
  
  <p>I get an error: Cannot open database "</p>
  
  <p>My aim is to once a month create a master table by appending every monthly file.</p>