View Single Post

   
  #4 (permalink)  
Old 02-28-2008, 08:16 AM
Sam Smith
 
Posts: n/a
Default Re: MS Access with MySQL - Speed Issues

"Thomas Bartkus" <thomasbartkus@comcast.net> wrote in message
newsan.2006.09.27.02.57.10.330577@comcast.net...

> Use the customization options on your query object to define it as a
> PassThrough query. Right click on the query, select "SQL Specific", then
> Select PassThrough query. Then make sure you use strict MySQL syntax
> as defined in the MySQL docs.
>
> This will bypass the Microsoft libraries (almost!) completely and let
> MySQL do it's query thing. MySQL is much better at it and everything
> works faster when Microsoft just butts out ;-)
>
> Thomas Bartkus


Thanks. I'll try that.

---
Sam


Reply With Quote