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
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
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.?
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.?
Sorry Andrew, I just spotted that you mentioned using exclusive mode in your original question.
I'll do a bit more research
I'll do a bit more research
ASKER
many thanks
Did you try decompiling the database to repair any corruption?
Did you try importing everything into an new blank database?
Did you try importing everything into an new blank database?
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.
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.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
excellent.
works a treat
works a treat
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