Hi kofa,
Thanks for using MSDN Managed Newsgroup Support.
Your SQL database administrator can choose to disable the access to store
the SQL database login IDs and passwords locally, requiring all users to
enter their login IDs and passwords each time they connect to a SQL
database.
To disable the ability to store login IDs and passwords locally, your SQL
database administrator must create a table called MSysConf in the SQL
database. When a user connects to the SQL database, Microsoft Access looks
for this table in the database and, if it finds it, queries the table. If
the values in the table correctly specify that local storing of login IDs
and passwords should be disabled, Microsoft Access does so, regardless of
whether the Save Login ID And Password Locally check box is selected. If
the table is not present or does not specify disabling of the feature,
users can store login IDs and passwords locally.
Please try to follow this KB article to setup the table:
How to store SQL database login IDs and passwords locally
http://support.microsoft.com/?id=209502
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
