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.
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
Additional query words: acc2000 Access 2000 acc2002 Access 2002 attach prb
Keywords: kbtshoot kbregistry kbdatabase kbprb kbdesign kbusage KB207823
