Pass-Through Queries prompt for DSN on execute

  • Thread starter Thread starter Nic
  • Start date Start date
N

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
 
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
 
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
 
Back
Top