Using A Dynamic Connection String for Access Pass Through Queries.

[timandsuzi36@hotmail.com]

Here's the issue. Appreciate any help any Access gurus can offer.

I have a .NET WinForms application that needs to launch a Access DB
application used for generating Access Reports. That part is no
problem.

However, this Access app is using Pass Through Queries to SQL for these
reports. I know that we can hard code a connection string for these
pass through queries to get at this data but I am needing this
connection string to be dynamic i.e. passing the connection string to
Access when it is launched or programmaticall y retrieving the
connection string from within access when it is launched.

Any ideas? Much appreciated!

[Tom van Stiphout]

Re: Using A Dynamic Connection String for Access Pass Through Queries.

On 6 May 2005 06:41:00 -0700, timandsuzi36@ho tmail.com wrote:

Pass the connect string during the launch. How to do that depends on
how you're launching:
* If running msaccess.exe, use the /x command line argument.
* If using automation, call a public function through the automation
interface.

-Tom.

[color=blue]
>Here's the issue. Appreciate any help any Access gurus can offer.
>
>I have a .NET WinForms application that needs to launch a Access DB
>application used for generating Access Reports. That part is no
>problem.
>
>However, this Access app is using Pass Through Queries to SQL for these
>reports. I know that we can hard code a connection string for these
>pass through queries to get at this data but I am needing this
>connection string to be dynamic i.e. passing the connection string to
>Access when it is launched or programmaticall y retrieving the
>connection string from within access when it is launched.
>
>Any ideas? Much appreciated![/color]