Bypass entering password to ODBC data sources

[antifashionpimp]

Hi everyone,

I was hoping somebody could assist me in this issue. I am quite a newbie to ODBC connections and was struggling to search for related topics. Here is my situation:

I have a Access 2000 .mdb file which has several linked tables to a ODBC data source, namely an Oracle back-end. I have already setup the connctions to these back-end tables in the ODBC Administrator, and it works fine. When I view one of these tables for the first time when opening the .mdb, there appears a form entitled “Oracle ODBC Driver Connect”, where the following fields are:

Service Name: blablabla
User Name: yours truly
Password: must be entered each time I start the .mdb new and view a linked table

Before I distibute my application, I want to create a generic User Name and Password on the back-end. But what I want to know is: How do I automate this procedure above in Access VBA, so that I don’t have to enter the password each time I start the .mdb file? In other words, how do I bypass the “Oracle ODBC Driver Connect” form with a hard-coded username and password?

Please help, as I am a bit lost at the moment. Even a few pointers as to where I can find some useful resources on the Net will be much appreciated.


Kind Regards,

J

 

[FoFa]

You can usually store the Userid and Password in the connection string. Usually you can specify that in the ODBC driver (to remember the Userid/Password) or you can set it in the connection string if a linked table, or at run time via code (ADO).