How to login "Oracle ODBC Driver Connect" in the programmatically

[wesbird]

Hi, I have MS Access 2007 application with a lot of ODBC linked table to
Oracle. When I start it, the code hide any one of linked tables, "Oracle
ODBC Driver Connect" dialog box popup and ask for password. I don't want my
user see this and type in password. How I can hide it and fill in the
password programmatically.

I'm using MS Access 2007 and VBA


Thank you,
Wes

 

[wesbird]

This only work for Access 2003. Now I'm working in 2007. Did you know if
there is update?


Thank you a lot for your time
Wes