Does access support batch query?

coolzy

My SQL is written as: SQL = "setlect * from table1; select * from table2;"
But write the system prompt like this:
  Syntax error: there is a statement after the SQL statement
    what's up?
 Does access not support batch query ???????????????

cairui1

Not supported, execute one by one

coolzy

No support? Can only be executed one by one! It really makes me depressed.
Thank youcairui1

cairui1

Yes, SQL SERVER can be executed, ACCESS can't