Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

In Memoriam

Terms of Use


VB Petition

Bugs: Database password appears to be set

Author(s)
Dev Ashish

  If your Access database starts prompting you for a password even though you never set one, it usually means that the mdb file was opened in another application, most typically Microsoft Word.

The mdb file structure, specified by Jet, is very specific, and a re-arrangement of even a few bytes could render the database corrupt; and a Save operation can rearrange the bytes. 

 Microsoft Word sometimes does not require you to specifically hit the Save button; because of background save option, macros, and probably some other settings, Word can automatically force a save without informing the user.  And if the file is a Jet database, this save operation could rearrange the information in a manner that forces Jet to think that a database password has been set.

Unfortunately, there's no workaround, other than to never open the database in anything other than the correct version of Access.  If your database is corrupt in this fashion, your best bet is to contact a data recovery service, such as PK Solutions, or restore from a clean backup, depending on how critical the data is.

For more information, view this Knowledge Base article.

Article ID: 243895
ACC2000: Database Password Appears Even Though It Was Never Set


1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer