Location of linked table username/password

From: Jason (pottsjc_at_omu.org)
Date: 02/06/04 

Date: Fri, 6 Feb 2004 09:02:37 -0800

Greetings,

When you link a table from a password-protected data
source and select save the password, MS Access stores the
username and password in the string contained in
MSysObjects.Connect. However, if you do not make this
selection, where does Access store this information?

I am trying to avoid creating yet another password for our
users. By having them log into the existing Oracle
database, then stripping that log-in information out, I
can use that information for the functionality I am
building in this database.

Thank you for the information.

Relevant Pages

  • Re: populate field by button press
    ... This assumes your form has a text control bound to the underlying field for ... Terminology note: Access stores values in fields, ... I have a field in my database that I would want to change the ...
    (microsoft.public.access.gettingstarted)
  • Re: Should I seperate my database?
    ... Since you have people, and groups, and group members, and (?Educational ... Opportunities), and "Education", I don't see an advantage to setting up two ... separate databases (recall that Access stores all tables and other objects ... Are you familiar with relational database design and normalization? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: newbie questions
    ... > Hello Chuck Bowling ... > There are few terms in database programming ... > database: it is a software which manages your data. ... > MS Access stores everything in .mdb file ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: newbie questions
    ... There are few terms in database programming ... database: it is a software which manages your data. ... there are differen type of databases you can categorized by vendor or ... MS Access stores everything in .mdb file ...
    (microsoft.public.dotnet.framework.adonet)