Avatar of andrewpiconnect
andrewpiconnect
Flag for United Kingdom of Great Britain and Northern Ireland asked on

remove a password i have set on my access 2010 database

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
Microsoft Access

Avatar of undefined
Last Comment
andrewpiconnect

8/22/2022 - Mon
Eirman

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
andrewpiconnect

ASKER
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.?
Eirman

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

I'll do a bit more research
Your help has saved me hundreds of hours of internet surfing.
fblack61
andrewpiconnect

ASKER
many thanks
Eirman

Did you try decompiling the database to repair any corruption?

Did you try importing everything into an new blank database?
Scott McDaniel (EE MVE )

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
andrewpiconnect

ASKER
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.
ASKER CERTIFIED SOLUTION
Eirman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
andrewpiconnect

ASKER
excellent.

works a treat