Excel Access and Oracle
 

My scenario..
I have an Access DB that contains a link table that points to an Oracle
table. Access to the Oracle table requires the user to login. Within this
access DB I have some queries that take data from the Oracle table and from
access tables to produce the result. In order to do some other stuff to the
data I use Excel and its Get External Data-New Database Query function to
point to the Access query. I have multiple excel tabs each containing one of
these access queries.

Within some Excel VBA code I call the query refresh function and do some
formatting to the results. The problem i would like to solve is... Each
time I call the QueryTAble.Refresh function the user must enter their
password to connect to the same oracle table. Is there a way to hardcode the
password into my code?

Thanks
Chris

Excel Access and Oracle
 

You might be able to do it using a dsn file with the user logging in as a
trusted connection, but the dba would probably have to get this one going. I
know that you can do this logging on to a SQL server and I'm assuming that
it's also possible with Oracle.
--
Kevin Backmann


"Chris K" wrote:

My scenario..
I have an Access DB that contains a link table that points to an Oracle
table. Access to the Oracle table requires the user to login. Within this
access DB I have some queries that take data from the Oracle table and from
access tables to produce the result. In order to do some other stuff to the
data I use Excel and its Get External Data-New Database Query function to
point to the Access query. I have multiple excel tabs each containing one of
these access queries.

Within some Excel VBA code I call the query refresh function and do some
formatting to the results. The problem i would like to solve is... Each
time I call the QueryTAble.Refresh function the user must enter their
password to connect to the same oracle table. Is there a way to hardcode the
password into my code?

Thanks
Chris