I have an MS Access database 2003 and am sending a query with date parameters (date/time)using mysql 3.51 ODBC driver. Since I have 9 queries that run with a Macro and all use the same date range, I put the start and end dates in an Access table and join it in to each query.
The problem, I have one Mysql 4.13 instance with two schemas db1 and db2. When I run 7 of the nine queries that run against db1, the dates work just fine and the data sets are pulled back.
But when I run the two queries that against db2, they send the queries to MySql without any date range. I know this because I run a "show full processlist" using MySQL Query Browser and see the query with no dates. So the Access database locks up then because the query will pull 37 million rows.
Now if I hard code the date range in the Access Query it works fine and pulls back the data.
Any ideas would be appreciated! Besides quit using Access.
Thanks alot,
Ron