Passthrough connection help

[hromberg@csatravelprotection.com]

I have a set of passthrough queries that rely on a temporary table in
SQL and currently I am dealing with this by creating a passthrough that
builds the table and leaves the connection open for an extended period
of time. However, rather than doing this I would like to open a
connection at the onset of opening the Access app and closing it when
done. My problem is: how do I create the open connection and use it in
all other passthrough queries? Any help would be apprecieated. Thanks.

[Neil]

Re: Passthrough connection help

I don't know if what you want to do is possible. But, instead of using a SQL
temporary table, why not just create your own temporary table, using the
current user's ID as a value in the table to make it unique to the user.
Populate the table when the app is opened, and clear it when it's closed.
Then you don't need a persistent connection.

Neil


<hromberg@csatr avelprotection. com> wrote in message
news:1111096247 .091120.258860@ z14g2000cwz.goo glegroups.com.. .[color=blue]
>I have a set of passthrough queries that rely on a temporary table in
> SQL and currently I am dealing with this by creating a passthrough that
> builds the table and leaves the connection open for an extended period
> of time. However, rather than doing this I would like to open a
> connection at the onset of opening the Access app and closing it when
> done. My problem is: how do I create the open connection and use it in
> all other passthrough queries? Any help would be apprecieated. Thanks.
>[/color]