Re: Automating login from MS Access front end

Yoau are right. That can be a problem. The password is stored in what Access calls the systemdatase. All users must share a common systemdatabase if it shall work proberly. To me it has worked fine with a prober setup of Access.

Besides of that youre solution is better. Having the full control in your own code is normally the best way of doing it :-)

/Jan

"Joseph Ranseth" <jransethNO_SPAM_at_hotmail.com> skrev i en meddelelse news:S2lc6.2482$wb7.67671_at_news1.mts.net...
> 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...
> > 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 Sat Jan 27 2001 - 05:10:56 CST