By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,811 Members | 785 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,811 IT Pros & Developers. It's quick & easy.

Passthrough connection help

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.