Pass-Through, Default DSN?

[Gerard]

Hey all,
I am running Access 2k on Win 2k with SQL Server 2k.
I am converting my companies Access database to SQL
Server. In the meantime while I develop the VB
application, we are using the Access database application
as a front end to connect to SQL Server. I made a Pass-
Through query so it connects to the ODBC to run the query,
instead of running it against the MSJet. This method is
much faster with one small exception. Every time the
query runs, a dialog pops up asking what DSN to connect
to. I want to eliminate that dialog. Is there a way to
specify a default DSN or something similar, so this dialog
doesn't pop up every time. As always, I appreciate all
the help in advance.

Gerard - GMS
Programmer / Processor

P.S. I have a box of recycled bits for the best post

 

[Les]

In the properties of the pass-thru query, you can set the
dsn information.

ODBC;DATABASE=yourdatabase;UID=yourid;PWD=yourpwd;DSN=DSNna
me

 

[Gerard]

Les,
When you right click on the query and go to
Properties, it only brings up a tab for "General"
properties, is there something I'm missing?

Gerard - GMS

 

[Les]

Gerard,
Open the passthru in design mode. Then, click to go to
properties.

Les

 

[Gerard]

Thanks Les

-----Original Message-----
Gerard,
Open the passthru in design mode. Then, click to go to N
.