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 open a
linked table/query
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