I'm trying to create a passthru query in Access against a MySQL database.
The following works if I use MySQL directly (using a query window in MySQL Workbench)
UPDATE `TEST_IMP` SET `strTestName` = 'hello'
WHERE `idItemizedTestList_ID` = '3';
SET `strTestName` = '22G' WHERE `idItemizedTestList_ID` = '44';
But when I put it in a passthru query in Access. It fails.
If I do each one individually in the pass thru query, the update works.
It only happens when I do two simultaneously.
I could always run separate passthrus for each Update, but I may have a few hundred updates and there will be a performance issue.
The ODBC driver reports an error on Line 4. Is there special syntax needed to have two UPDATES in a passthru?
Remember, the full statement works when using Workbench. So, I know the syntax should be correct.