Pass-Through, Default DSN?

From: Les (anonymous_at_discussions.microsoft.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 10:08:51 -0700

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=DSN
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 ;)
>>>.
>>>
>>.
>>
>.
>

Relevant Pages

  • Pass-Through, Default DSN?
    ... > Open the passthru in design mode. ... >> When you right click on the query and go to ... is there something I'm missing? ...
    (microsoft.public.access.queries)
  • Re: Adding a new field in MSAccess DB ( newbie )
    ... Open the table in design mode and add the new field ... select the first cell of the date field and paste. ... not allow conversion, ... I would write a make table query. ...
    (microsoft.public.vb.general.discussion)
  • Re: Please Help, second post
    ... "Les Coover" wrote in message ... > Created the Query then built the Form based on the Query. ... >> Doug Steele, Microsoft Access MVP ... >> (no e-mails, please!) ...
    (microsoft.public.access.formscoding)
  • Re: Query will not open in Design Mode - Invalid use of Null
    ... can open thequeryin Design Mode to edit - I can view in sql mode. ... I have 3 records in Copy of tblCoa and 4 ... The query runs fine, the query will toggle back and forth from design ...
    (microsoft.public.access.queries)
  • RE: queries and parm
    ... "Les" wrote: ... for a parm and then run the query. ... but if you base a form on a query that has a criteria ... if I say OK and leave the parm empty the form opens correctly if I ...
    (microsoft.public.access.queries)