I am trying to carry out a statement like:
UPDATE table1 SET name="Joe" WHERE id='1'; UPDATE table2 SET name="Bob" WHERE id='2'
But, when performing the query, I recieve:
Microsoft JET Database Engine error '80040e14' Figures found after finish of SQL statement.
It really works after i execute the claims individually, though.
So I am speculating there's no way to complete multiple queries in one SQL statement when utilizing Microsoft Access/JET database engine?
No, there's no method of doing this except through VBA or so on, once the claims could be Performed seperately, but like a single procedure.