Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 246033 - Last Review: January 26, 2005 - Revision: 2.2
You receive a "Not a Valid Password" error message when you open an Access 97 database in Access 2000
This article was previously published under Q246033
Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
When you open a Microsoft Access 97 database in Microsoft Access 2000, and if the database password has 14 or more characters, you may receive the following error message:
To work around this behavior, follow these steps:
-
Start Microsoft Access 97.
-
Open the database, and then type the password.
-
On the Tools menu, click Security, and then click Unset Database Password.
-
Type the password for the database, and then click OK.
The database no longer has a password. At this point, you can open the database in Access 2000 without a password, or you can continue with the following steps to set another password:
-
In Access 97, on the Tools menu, click Security, and then click Set Database Password.
-
Type a password that has fewer than 14 characters, and then click OK.
-
Open the database in Access 2000 with the new password.
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce Behavior
-
Start Access 97.
-
Create a new database.
-
On the Tools menu, click Security, and then click Set Database Password
-
Type any 14 characters (or more) for the password; for example, type one of the following:
-
RANDYNUMANCARS
-
1234567890123456789
-
AAAAAAAAAAAAAA
-
Quit Access 97.
-
Start Access 2000.
-
In Access 2000, open the Access 97 database that you created in step 2.
-
When prompted, type the correct password, and then click OK. Note that you receive the following error message:
For more information about passwords, click
Microsoft
Visual Basic Help on the
Help menu, type
password property in the Office Assistant or the Answer Wizard, and then
click
Search to view
"Password Property."
For more information about passwords, click
Microsoft Access Help on the
Help menu, type
create or change a security account password in the Office Assistant or the Answer Wizard, and then
click
Search to view
"Create or change a security account password."
APPLIES TO
- Microsoft Access 2000 Standard Edition
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