G
Guest
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
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