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

 

[fredflick]

Nice quick answer

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

>-----Original Message-----
>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
>.
>

Wish there were more 'newbie friendly' people like you