multiple statement Passthrough query - ODBC call failed Access 2010

[krish chris]

Hi there,

im using MySQL as back-end for Access 2010 and I came across to a weird situation. I can execute single statement in a pass-through query but when i add another one it gives me ODBC-call failed.

e.g:
I can successfully run this code in my pass-through query:
INSERT INTO `tbl_cluster` (`cluster`,`description`) VALUES ('Cluster name', ' first entry');

but when i add another statement it gives an error saying odbc call failed.
e.g
INSERT INTO `tbl_cluster` (`cluster`,`description`) VALUES ('Cluster name', ' first entry');
INSERT INTO `tbl_cluster` (`cluster`,`description`) VALUES ('Second name', ' second entry');


I was assuming, everything in the pass-through query is directly passed to the server. Am I missing anything?

thanks for help