title: Running multiple SQL statements in the one operation
body: <p>I'm trying to use ADO to create several tables at once, into MS Access. Is it possible to do multiple statements in the one operation? For instance:</p>
  
  <pre><code>...
  // I have omitted the field details 
  CString sQuery = "CREATE TABLE [Table1] (..., PRIMARY KEY ([ID])); \nCREATE TABLE [Table2] (..., PRIMARY KEY ([ID]));";
  oRecordset.Open(oDatabase.m_pConnection, sQuery)
  </code></pre>
  
  <p>This fails due to a <code>"Syntax Error in CREATE TABLE statement"</code>, although each of the create statements work on their own perfectly. Is there a way of doing this sort of thing? There will also be statements to add constraints, add indexing, etc., and I'd really like to be able to do it so that I don't have to split up the string into separate parts.</p>