Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / April 2008

Tip: Looking for answers? Try searching our database.

Can't clear the password

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Margaret Bartley - 29 Apr 2008 02:05 GMT
Environment:
 Access 2003 SP2
 opening an Access 2002-2003 file on my local hard drive
 on WinXP machine.

My client received a password-protected database that I am going to work
with.
The password works fine, I can open the database, but I want to clear the
password.

I set the default to Open Exclusive:
Tools | Options | Advanced and selected Exclusive and Default open mode and
closed Access.

Made sure the file was specifically opened exclusively:
Opened Access, selected File, Open, selected my password-protected file,
clicked on the down-arrow to the right of the "Open" box, which was already
checked as "Open Exclusive", and it opened, prompted me for the password,
which I entered.

Tried to clear the password:
Tools | Security | Unset Database Password

Got the error message:
"You need to have the database open for exclusive use to set or unset the
database password.

To open the database exclusively, close the database, and then reopen it
using the Open command on the file menu.  In the Open dialog box, click the
arrow to the right of the Open button, and then chooose Open Exclusive."

So, now what?
Chris O'C - 29 Apr 2008 02:44 GMT
A reliable way to open the database exclusively is to use the /excl switch.
I put it in a shortcut's target.

"Path to Msaccess.exe" "Path to db" /excl

Chris
Microsoft MVP

>Environment:
>  Access 2003 SP2
[quoted text clipped - 28 lines]
>
>So, now what?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.