Remove Password - Access 2003

Y

yo

I originally password-protected my database, but now I want to remove this
password so anyone can access the database. (Access 2003)
 
P

Pyrite

Open the database exclusively, to do this open from file menu, select file
and use the little arrow next to 'open' then choose exclusive from the list.
When it opens select 'Tools', 'Security', 'Unset Database Password'. It will
ask for the password and then remove it. This is presuming it was a database
password that you set that prevents the file being opened without it. If it
is more specific user-level security please give more detail.
 
J

John Spencer

Open up the database (exclusive) in design view and then clear the password.
-- Start Access
-- Select File : Open from the menu
-- Find your database
-- Click the down arrow on the Open button and "Open Exclusive"
-- Select Tools: Security: Unset Database Password

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Top