[AccessD] Harnessing SQL Server with runtime

There is a property in the design view, ODBC Connect String.

My local development copy looks something like this:
ODBC;DRIVER=SQL 
Server;SERVER=tg9078;UID=sa;PWD=monkey;DATABASE=WWCI_Master_Data

Once that is filled in, you should not get any more hits asking you 
for that info.

At 09:27 AM 3/19/2011, you wrote:
>Date: Fri, 18 Mar 2011 08:18:20 -0400
>From: jwcolby <jwcolby at colbyconsulting.com>
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Harnessing SQL Server with runtime
>Message-ID: <4D834D8C.4040806 at colbyconsulting.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>Robert,
>
>What specific things have to be done to use the pass-through query?
>
>I took a regular query using a table linked to SQL Server and made 
>it pass-through by changing the
>sql specific to pass through.  It immediately asked me for a dsn, 
>and when I gave it one it asked me
>for the user name / password.  But it keeps asking me for the dsn / 
>user name / password any time I
>do anything with that query or the form that is bound to that query.
>
>Am I missing something?
>
>John W. Colby
>www.ColbyConsulting.com