Pass-Through, Default DSN?
From: Gerard (anonymous_at_discussions.microsoft.com)
Date: 04/29/04
- Next message: David: "'Query does not exist' message but it does !?!"
- Previous message: JackP: "Convert ROW data to COLUMN"
- In reply to: Les: "Pass-Through, Default DSN?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Apr 2004 11:35:28 -0700
Thanks Les
>-----Original Message-----
>Gerard,
> Open the passthru in design mode. Then, click to go
to
>properties.
>
>Les
>>-----Original Message-----
>>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
>>
>>>-----Original Message-----
>>>In the properties of the pass-thru query, you can set
>the
>>>dsn information.
>>>
>>>ODBC;DATABASE=yourdatabase;UID=yourid;PWD=yourpwd;DSN=DS
N
>n
>>a
>>>me
>>>>-----Original Message-----
>>>>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 ;)
>>>>.
>>>>
>>>.
>>>
>>.
>>
>.
>
- Next message: David: "'Query does not exist' message but it does !?!"
- Previous message: JackP: "Convert ROW data to COLUMN"
- In reply to: Les: "Pass-Through, Default DSN?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
