I have an Access 2003 database linked via ODBC using MYSQL ODBC version 5.1
It works very well apart from UNION queries with more than 1 UNION
If I run a query with 2 UNIONS then I get an Error
ODBC – call failed. (Error 3146)
The query in Question is like this one
If I run this on MYSQL then it is fine
If I run it on ACCESS I get the ODBC error
If I run any pair of the Union Such as
It is fine.
Looks like an issue with the MYSQL ODBC Adapter.
BUT...IF I write it as a PASS THROUGH query running on the server with the same adapter DSN, then it is fine.
Anyone any ideas of whether it is possible to get round this issue IN ACCESS
without resorting to temporary tables OR PASS Through query.