title: In MS Access, is it possible to execute multiple queries?
body: <p>I'm trying to execute a statement like:</p>
  
  <p><code>UPDATE table1 SET name="Joe" WHERE id='1'; UPDATE table2 SET name="Bob" WHERE id='2'</code></p>
  
  <p>But, when executing the query, I get:</p>
  
  <blockquote>Microsoft JET Database Engine error '80040e14'
  
  Characters found after end of SQL statement.</blockquote>
  
  <p>It works when I execute the statements separately, though.</p>
  
  <p>So I'm guessing there's absolutely no way to execute multiple queries in a single SQL statement when using Microsoft Access/JET database engine?</p>