title: VBScript to `drop` and `create` new table in microsoft access
body: <p>I have VBScript to <code>drop</code> and <code>create</code> new table in microsoft access. 
  <strong>My vb script is :</strong></p>
  
  <pre><code>Set dbeng = CreateObject("DAO.DBEngine.120")
  strMdbFile = "amw\db_amw.accdb"
  Set db = dbeng.OpenDatabase(strMdbFile)
  strSql1 = "DROP TABLE amw"
  StrSql2 = "SELECT * INTO amw FROM MPN_V WHERE (((Format([tgl_bayar],'yyyy')) Between Format(Now(),'yyyy')-2 And Format(Now(),'yyyy')))"
  strSql3 = "DROP TABLE UPDATE"
  strSql4 = "SELECT * INTO update FROM UPDATE6 WHERE id="1""
  
  db.Execute(strSql1)
  db.Execute(strSql2)
  db.Execute(strSql3)
  db.Execute(strSql4)
  </code></pre>
  
  <p>when the script runs the line <code>db.Execute(strSql1)</code> and <code>db.Execute(strSql2)</code>, no error Happen. but, when the script runs the line <code>db.Execute(strSql3)</code> and <code>db.Execute(strSql4)</code>, error Happen : <code>Expected end of statement, code 800A0401, source Microsoft VBScript compilation error</code>. Please correct my Script? thank you verymuch</p>