Microsoft KB Archive/207823

= "Save Password" check box is unavailable when you link ODBC tables =

Article ID: 207823

Article Last Modified on 8/6/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition
 * Microsoft Access 2002 Standard Edition

-



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.



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:

-or-

For Microsoft Access 2000

For Microsoft Access 2002

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.

