Passthrough Queries and Linked Tables 1

[CandyT]

I have seen this done before but do not how how to make it work:

I have linked my Access db to several tables in an Oracle database via ODBC. The Oracle database has an Id and password. I have seen someone put in a passthrough query that opened up the ODBC connection so that you did not have to re-enter the Oracle ID and password each time you run queries from those tables. Also, if I get an answer to that one, I also need to know if you can use the same query to prompt for the password the first time and then keep the ODBC connection continuously open after that for as long as the Access db is open.

Thank you!

Candy T

 

[JohnBlaze]

In pass through qurey design, right click on the query window. Go to properties.
Under ODBC connect string you will see '...'
Hit on that and then set your password/logon

To my knowledge with ODBC tables, you save the password when you initialy set up the link to the table

-John Blaze

 

[CandyT]

Thank you! That's it!