Sub routine to automatically log into oracle ODBC server

[saracen666]

Hi,
I use linked ODBC tables to access tables on a server. I run queries to download fields I need from these links. It requires a login which I want to automate in VBA code. How can I automate this so I do not have to login all the time?

Many thanks.

 

[Ranman256]

You don't need code.
The ODBC holds the login info when you attach the tables.
Then you only need to dbl-click a table to open it.

 

[saracen666]

Hi,
Thanks for your response. I am looking for my access file to autoexec the download from the ODBC tables on open. Unfortunately every time I open the access file on the first use I have to enter my password at the prompt. I want to automate this so it logs in on file open.

My company doesn't allow permanent storage of password so think I have to VBA code it in auto exec.

I will be scheduling the file to run outside of normal working hours.

 

[Minty]

Well if you use VBA to enter the password, by definition you will have stored it in order to enter it.

May as well save it in the ODBC settings where no one can get to it, unlike buried in your code where someone​ savvy could find it.

Sent from my Nexus 7 using Tapatalk

 

[saracen666]

How do I store it in the ODBC settings?