This article applies only to a Microsoft Access database (.mdb and .accdb).
- There is a MSysConf table on the SQL database server, which prohibits users from storing passwords locally.
- 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 ServerThe 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:
To re-enable users to save logon IDs and passwords locally, change the record to:
Cause 2: Network Password Caching Has Been DisabledEdit 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:
For Microsoft Access 2000
For Microsoft Access 2002
NOTE: If you have no plans to ever use the DisablePwdCaching key, you can delete it.
- 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.
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:
ID článku: 207823 – Posledná kontrola: 7. 1. 2017 – Revízia: 1