Passthrough connection help

[hromberg]

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]

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
<hr******@csatravelprotection.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.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.