Re: How to use MS Access pass through query with MySQL

[Jay Alverson]

James Choi Wrote:
-------------------------------------------------------
> Can anyone please help me!
>
> I have relatively very simple query.
> When I run it in native MS Access DB as back end
> this query runs fine but
> when I try to run the query in link MySQL DB as
> back end then query runs incredibly slow.

I think any type of Linked Query is going to be slow with
Access.

I remember using Access to Link with MS-SQL db to run reports
took 6+ hours for only a few 1000 records.

I've had other people say the same.

Try using ADO or some other method using the same steps and
see if it's faster.

>

Thanks, Jay