password

[Walley]

Hi!
How can I remove a password from Access 2007 document.
Thanks for the help.

 

[Tom Wickerath]

Hi Walley,

The process is very similar to the one you used for encrypting the database
with the password: Open your database file. Then click on the Database Tools
tab of the ribbon. You should see a choice to remove the encryption &
password.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Hans Up]

How can I remove a password from Access 2007 document.

Open your database in Exclusive mode, using the same instructions Tom
gave you when you asked how to set the password.

Select the "Database Tools" tab on the ribbon.

Click on "Decrypt Database".

Access will prompt you for the password one last time, then decrypt the
database and discard the password.

 

[Carolyn]

I have an Access 2007 database that I upgraded from Access 2000. I had no
problem decrypting the database before I upgraded it to .accdb and setting up
a new password on the upgraded version. The problem now is that when I close
the database it prompts me for a password; after I re-enter the password I
get an error message saying "Not a valid password". I end up having to cancel
in order to close the database.

When I open it exclusively I only see the "Encrypt with password" option
under database tools, so I cannot remove the password to try to fix this
issue.

My main concern is that I have this database set to compact and repair on
close and I do not see that this is happening with this password issue.

I followed the same procedure with 2 other databases and have had no
problems.

I am the only user and the database is not split.

I ended up creating a new database and imported everything from the database
with the password. Until I can find or someone else has a solution to this
problem, I won't set a password on the newly created database.
It is compacting so that's a step in the right direction...
Is there any other way to secure a database?

Any help would be greatly appreciated.
Thank you in advance,
Carolyn

 

[Hans Up]

I ended up creating a new database and imported everything from the database
with the password. Until I can find or someone else has a solution to this
problem, I won't set a password on the newly created database.

Why not? If you're concerned, you can make a copy of the newly created
database and "encrypt with password" on the copy.

It is compacting so that's a step in the right direction...

I think compact on close is discouraged by the Access Most Valuable
Professionals. You should be able to find plenty of posts in this
newsgroup which explain why.

Is there any other way to secure a database?

The Access 2002-2003 MDB format is supported by Access 2007 (it's a
"native" format for 2007). You could convert your ACCDB to MDB and
apply user level security to the MDB. However, ULS is considerably more
challenging (than encrypt with password) to set up properly.