remove a password i have set on my access 2010 database

andrewpiconnect
andrewpiconnect used Ask the Experts™
on
Hi,

I have set a password on my access 2010 database and now wish to remove it.

I know the password but i am unable to find a way to remove it.

If i open it in exclusive mode I am promtped to put in the password and then i get to option to set a new password. But whatever i enter its says "not a valid password" if i try and set a new one.

Totally miffed by this so would appreciate any assistance
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
EirmanChief Operations Manager

Commented:
You'll find quite good instructions here
http://www.addictivetips.com/microsoft-office/password-protect-access-2010-database-encrypt-decrypt/

The key thing is that you must have exclusive access (no sharing) to the database when changing/removing the password

Author

Commented:
Hi Eirman,

I have already opened the db in exclusive mode but the option to "Decrypt" the database is not there, even though i have previously encrypted it with a password.?
EirmanChief Operations Manager

Commented:
Sorry Andrew, I just spotted that you mentioned using exclusive mode in your original question.

I'll do a bit more research
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
many thanks
EirmanChief Operations Manager

Commented:
Did you try decompiling the database to repair any corruption?

Did you try importing everything into an new blank database?
Most Valuable Expert 2012
Top Expert 2014

Commented:
Can you log into the database using your current password?

This Microsoft KB article shows how to decrypt:

http://office.microsoft.com/en-us/access-help/encrypt-a-database-by-using-a-database-password-HA010341664.aspx#BM4

If you do NOT see the Decrypt option, then either (a) you're working on the wrong database (or wrong copy) or (b) there's something wrong with the installation of Office (or Windows) or (c) there's something wrong with the database.

Obviously you should be sure you're working on the correct database (and I'm sure you are).

Make sure that your Windows and Office installations are fully up to date.

If there is something wrong with the database, then as Eirman suggests moving to a new, blank database may help - but you have to be able to log into the current database first.

Author

Commented:
yes i have compiled the db and decomplied the db

i am now importing all the forms, queries, modules, reports into a new database (without a password) as this seems to be the only option available to me.
Chief Operations Manager
Commented:
I found this piece of info

It is possible to remove the password as follows:
- Press Ctrl+G to activate the Immediate window in the Visual Basic Editor.
- Type or copy/paste the following line:

Code: Select all
    CurrentDb.NewPassword "enter old password", ""


- With the insertion point anywhere in the line, press Enter.
- Switch back to Access.

Author

Commented:
excellent.

works a treat

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial