Access 2007 Remove Password

[evajen01]

Hi,

I've inherited a database that was created in a previous version of Access,
and subsequently converted to Access 2007. The database had a password set
in its previous version. I can still open the database with this password,
but I would like to remove it. However, when I open the database exclusively
in Access 2007, I do not see the Remove Password option under the Database
Tools ribbon tab (which is where I nornally see the Remove Password option.)
Is there any other way to remove the password?

 

[Jerry Whittle]

Do you see an Encrypt option? It might be there. From Help: You set and
remove a database password in Microsoft Office Access 2007 by using the Set
Database Password and Unset Database Password dialog boxes. These dialog
boxes appear when you click the Encrypt with Password command and the Remove
Database Password And Encryption command , respectively, in the Database
Tools group on the Database Tools tab.

Are you sure that they used Access' password protection and not some
homebrewed password? Try opening the database while holding down the F11 key.
If you aren't prompted for a password, it was homebrewed. If the F11 key is
disabled, check out the code behind the opening form.

 

[evajen01]

Hi Jerry,

The behavior is very strange. The password was created when the database
was in Access 2003 format, using Access password technology. Then, the
database was converted to Access 2007. Now, when I try to open the database,
it prompts me for a password, which I expect. I enter the password, and I'm
able to access the database just fine. However, I can't find any option to
remove the password. I tried opening the database exlusively and looking on
the Database Tools tab of the ribbon, but do not see a Remove Password option
like I normally see in Access 2007. I did try to press the Encrypt with
Password button, and was prompted to set-up a new password. However,
anything I entered was not accepted, giving me the message of "Not a valid
password", even though I was following all of the password rules.

Thanks!

 

[evajen01]

Just wanted to mention that I came up with a work-around solution for
removing a password from an Access 2007 database, where the password was
created in a previous version of the tool. I'm not sure if it is the most
elegant or efficient, but it worked. It involved setting up a shell database
and running a subprocedure that uses ADO to executed the ALTER DATABASE
PASSWORD command. If anyone is interested, I have a more complete write-up
at my blog:
http://vajentic.blogspot.com/2008/08/removing-password-that-was-created-in.html