"Save Password" check box is unavailable when you link ODBC tables (207823)


The information in this article applies to:

  • Microsoft Access 2000
  • Microsoft Access 2002
This article was previously published under Q207823
For a Microsoft Access 97 version of this article, see 164003.
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

Advanced: Requires expert coding, interoperability, and multiuser skills.

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

SYMPTOMS

You may not be able to save your logon ID and password locally when you link a table from an Open Database Connectivity (ODBC) data source because the Save password check box is unavailable in the Link Tables dialog box.

CAUSE

This behavior can occur for the following reasons:
  • There is a MSysConf table on the SQL database server, which prohibits users from storing passwords locally.

    -or-
  • The registry has been modified so that network password caching has been disabled on your computer.

RESOLUTION

Cause 1: There Is a MSysConf Table on the SQL Database Server

The server administrator has disabled local storage of the logon IDs and passwords in linked tables by creating a MSysConf table on the server, which contains the following record: 
   Config          nValue
   ------          ------
    101               0
To re-enable users to save logon IDs and passwords locally, change the record to: 
   Config          nValue
   ------          ------
    101               1

Cause 2: Network Password Caching Has Been Disabled

Edit the registry to enable network password caching.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

Use the Registry Editor to set the DisablePwdCaching key to a decimal value of 0. This registry key may be stored in either of the following hives:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\Network\
-or-

For Microsoft Access 2000

HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\Common\

For Microsoft Access 2002

HKEY_LOCAL_MACHINE\Software\Microsoft\Office\10.0\Common\

NOTE: If you have no plans to ever use the DisablePwdCaching key, you can delete it.

MORE INFORMATION

If you are administering an SQL database that uses Microsoft Access as the front-end program, you can create a table in your SQL database named MSysConf to help control communication between the two programs. The MSysConf table has two potential functions:
  • It can disable the feature that enables users to save the logon ID and password for a linked SQL database in Access.
  • It can optimize how Access performs background population of records during idle time by setting the number of rows of data that are retrieved at one time and the number of seconds of delay between each retrieval.

REFERENCES

For additional information about using the MSysConf table to prevent the storage of logon IDs and passwords locally, click the article number below to view the article in the Microsoft Knowledge Base:

209502 ACC2000: Storing SQL Database Login IDs and Passwords Locally

For more information about the MSysConf table, click Microsoft Access Help on the Help menu, type use the msysconf table in a microsoft access database with linked sql databases in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For additional information about disabling password caching using the Policy Editor in Microsoft Windows, click the article number below to view the article in the Microsoft Knowledge Base:

142233 No Password Prompt After Network Adapter Is Detected

Modification Type:MajorLast Reviewed:8/6/2004
Keywords:kbDatabase kbdesign kbtshoot kbRegistry kbprb kbusage KB207823 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.