title: Multiple UPDATEs in one Access SQL query
body: <p>I'm trying to make a query like so:</p>
  
  <pre><code>UPDATE table1 SET col1 = 'foo', col2 = 'bar';
  UPDATE table2 SET hi = 'bye', bye = 'hi';
  </code></pre>
  
  <p>But when I go to save, Access errors with:</p>
  
  <blockquote>
    <p>Characters found after end of SQL statement</p>
  </blockquote>
  
  <p>After some searching, it would appear this is because Access can only do one query at a time.</p>
  
  <p>How can I do this?</p>