Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 926802 - Last Review: October 15, 2007 - Revision: 1.2
You are not prompted to save a password when you link to an encrypted Access 2007 database
You link to a table in an encrypted Microsoft Office Access 2007 database from another Access 2007 database. When you do this, you are not prompted to save the password for the encrypted database. Additionally, the password is saved as plain text within the binary file format of the Access 2007 database file in which you created the link.
This issue occurs when the Access 2007 database in which you created the link is not encrypted.
To work around this issue, you must encrypt any Access 2007 database that links to an encrypted Access 2007 database. To do this, follow these steps:
- Open the Access 2007 database that you want to encrypt.
- On the Database Tools tab, click Encrypt with Password in the Database Tools group.
- In the Set Database Password dialog box, type a password into the Password box, and then type the same password into the Verify box.
- Click OK, and then save the database.
For more information about how Access 2007 helps protect your databases, see the "Security and privacy" topic in the Access 2007 Help file.
APPLIES TO
- Microsoft Office Access 2007
| kbtshoot kbdatabase kbprb kbpasswords kbexpertiseinter KB926802 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate