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

[Marc Ozin]

Hi James,
I've just reread your code. On first glance I thought it was picking up parameters to use but now I'm more awake I can see it's not.
It looks like you're updating records in tblmembers with data from tblmemberTemp.

You're right. A straight SQL pass though should be able to handle that a shed load quicker than having to step though each one in access.

The first post I wrote should show you how to create a pass through where you can execute the SQL you need.

All the best.

PS I did find a way to pass parameters (not very neatly tho). You can see that too in the thread I started if you're interested.