Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Automating login from MS Access front end
Our Access front-end to an Oracle back-end uses Access security, meaning the user has to log in to Access to start the app. If the username/password combination in Access matches one defined in Oracle, there is no prompt for the Oracle login.
Access has command-line parameters that allow you to specify the username and password for starting Access, and store that in the shortcut icon target line. If the security of the Oracle password is not crucial, you could implement minimal Access security (basically just require an Access login) and make the Oracle connection happen quietly.
Any system for storing the Oracle password is going to make that password easily retrievable, as far as I know.
Hope this helps,
Anne Nolan
In article <3A70B9B8.B21E75D6_at_nau.edu>,
Ernie.DeVries_at_nau.edu wrote:
> I have an MS Access97 database which includes Oracle tables as linked
> tables. The first time I access one of the linked Oracle tables I am
> prompted to provide the user id and password. Once the login has been
> accomplished, the connection remains live and the information for
login
> is cached. I want to be able to provide this information
> programmatically so that my users aren't aware that I'm retrieving
> external data in the background. Getting the user id and password is
no
> problem. The challenge is providing it so that the user won't get
> prompted by the ODBC data source the first time a connection is made.
>
> I've been able to do this using an ODBCDirect type connection, but I
> really need to be able to use a query that I developed in Access'
query
> builder and that goes against the linked table to select records.
>
> I know this is more of an Access question than an Oracle question, but
> I'm hoping that there is someone here with experience in using Access
as
> a front-end to Oracle and can provide me with some direction on this
> project.
>
Sent via Deja.com
http://www.deja.com/
Received on Mon Jan 29 2001 - 10:57:14 CST