Access Oracle ODBC

[Guest]

I am an old programmer but new to Oracle and Access. I have ann Access
frontend and Oracle data files backend. When I link the files manually, the
access system works fine. My problem is that the user must enter a username
and password. They do not want to do this, therefore I want to hardcode the
the link to the Oracle data. I have tried using TransferDbase in a macro and
copied the data base name from the manual link that I have made (as the
"HELP" function on the data base field field advised), but I get an error -
"ODBC -- connection to 'Schema' failed."

Can anybody help or suggest where I can read more or where I can find
examples that will show me what to do?

 

[Guest]

Connect to the Oracle back end via an Access "pass-through" query. In the
properties of that query, you can specify the user name and password within
the connection string.

Keep in mind to use a pass through query, you must write the SQL in PL/SQL
(Oracle's flavor).

 

[Guest]

Thank you for the help. I have found another way. When I create the ODBC
connection, I create a file data source and selected it. The next step I
have to select the file I want. On that selection screen at the bottom right
I select the "save password" box. The ODBC link is then created and when I
select the ODBC linked file in Access, it does not require a password.