Re: Automating login from MS Access front end

An very simple and easy way to do this is to tell Access to remeber the password !!

When you are attaching the tables you have a list of all tables from your source. In the buttom of that form in Acces there a little checkbox. Marking this tells Access to remember the password, so that there will be no prompting when the connection is made from your app.

Just a simple way. Don't know if its the way you want it to work...

Best regards,
Jan

"Ernie DeVries" <Ernie.DeVries_at_nau.edu> skrev i en meddelelse news:3A70B9B8.B21E75D6_at_nau.edu...
> 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.
Received on Thu Jan 25 2001 - 18:07:34 CST