Pass-Through Queries prompt for DSN on execute

[Nic]

Hello all -
I am trying to setup a Pass-through query in Access to a MySQL server. I
have a system DSN setup to the database, just everytime I try to execute
the pass-through query it bugs me about selecting my DSN. I just want it
to remember to always use that DSN or better yet always use a specific DSN
for all pass-through queries. I can't even set the recordsource of any
form to a pass-through query because when I do Access gets in a loop where
it won't leave me alone about selecting a DSN and I eventually have to
Kill Access. I'm using Access 2003, any help would be most appreciated!

-Nic

 

[Rosco_t89]

1. Open your pass thru query in design mode. Next open the
properties box.

2. Enter your dsn in the ODBC Connect Str property.

Hope this helps
Rosco

 

[Nic]

Thank you so very much! Most of the time things in Access are obvious to
me, but for some reason this one was not. My application is running a LOT
faster now! Thanks!

-Nic