Microsoft KB Archive/275111

= ACC2002: You Are Prompted for Oracle Password Even If You Select &quot;Save Password&quot; =

Article ID: 275111

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition, when used with:
 * Microsoft Windows 2000 Standard Edition

-



This article was previously published under Q275111



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
On a Microsoft Windows 2000-based computer, when you use the Oracle 7.3 ODBC driver, you are prompted for an Oracle password to access an Oracle linked table even after you have click to select the Save Password check box in the List Tables dialog box.



RESOLUTION
On a Windows 2000-based computer, you must supply the password each time that you access your Oracle linked table even if you have clicked to select the Save Password check box.



STATUS
Microsoft has confirmed that this is a problem in Access 2002.



Steps to Reproduce the Behavior

 * 1) Install Windows 2000.
 * 2) Install Access 2002.
 * 3) Install the Oracle 7.3 client.
 * 4) Click Start, point to Programs, point to Administrative Tools, and then click Data Sources (ODBC).
 * 5) Create a System DSN that uses the Oracle ODBC driver. Specify a server name of ORACLE734. Provide a valid user name and password.
 * 6) In Access 2002, link any Oracle table on the Oracle server by using the DSN that you created in the previous step.
 * 7) In the Link Tables dialog box (where the list of tables that you can link to is provided), click to select the Save Password check box.
 * 8) Double-click the Oracle linked table. In Datasheet view, you should be able to see the table data and you should not be prompted for a password.
 * 9) Quit Access.
 * 10) Start Access, and then open the database that contains the linked Oracle table.
 * 11) Double-click the Oracle linked table. Note that you are prompted for a password.

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Additional query words: pra linked oracle odbc password save

Keywords: kbbug kbnofix KB275111

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.