MS Access Union Query to mysql back back end
Posted on 2005-04-14
I've got MySQL server 4.1.1 as a back end containing my tables and (was handed) MS Access as the front end solution using MyODBC 3.56.11-2. I've written some union queries in MySQL Query Browser to gather information from multiple tables. Since MySQL and Access deal with dates, date related functions, and intervals between dates, differently when I copy/paste some of my queries into Access they fail. Is there a way I can have Access ignore any problems it thinks I have with my SQL syntax and just dump the query to the server? It'll get results if it does as the queries work when I test them with Query Browser.