Hi,
I have an Access front-end that connects to a backend that includes linked Oracle tables. The problem is that whenever I click on a function that uses one of the Oracle tables, I am promted for the Oracle login. It seems as if there is a way to store this userid and password information, since none of my other Access databases (which also contain linked Oracle tables in the backend) produce this prompt.
I thought I could store the password in the ODBC driver, but the Microsoft Oracle driver does not let me store the password. Is there some place where I can store it?
Thanks.
I have an Access front-end that connects to a backend that includes linked Oracle tables. The problem is that whenever I click on a function that uses one of the Oracle tables, I am promted for the Oracle login. It seems as if there is a way to store this userid and password information, since none of my other Access databases (which also contain linked Oracle tables in the backend) produce this prompt.
I thought I could store the password in the ODBC driver, but the Microsoft Oracle driver does not let me store the password. Is there some place where I can store it?
Thanks.