Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Automating login from MS Access front end
In my experience, access doesn't remember the passwords very well -
basically, NEVER.
What you should do is create a procedure in VB code that will connect to the
database via odbc. Have the procedure placed in your startup macro or
code - whichever you are using.
hth,
-- Joseph Ranseth - Webmaster World Cup Fishing www.worldcupfishing.com "Jan Elbæk" <jael_at_worldonline.dk> wrote in message news:Va3c6.15313$l57.548579_at_news000.worldonline.dk...Received on Fri Jan 26 2001 - 14:20:46 CST
> 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.
>
>