?
Solved

Remove password from MS access database

Posted on 2008-10-14
6
Medium Priority
?
3,983 Views
Last Modified: 2013-11-29
I am having a password protected Database in msaccess. what i need is to remove protection from this database. I want this same database which is not password protected. how can i achieve it.
0
Comment
Question by:Kumawat_Shobha
  • 3
5 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 375 total points
ID: 22709415
If you know tha password, then:

Open the DB with the password
Click: Tools--Security--Un-set Database Password.

If you do not know the password, you are out of luck.

We are not allowed to suggest ways of bypassing a Databas's Security.

JeffCoachman
0
 
LVL 1

Author Comment

by:Kumawat_Shobha
ID: 22709821
Look, i want to make this database having no password protection. and with the method suggested above i could reset the current password with the new one.
hope you got the issue..
0
 
LVL 75
ID: 22712667
:-)

mx
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22715315
Kumawat_Shobha,

Yes, Un-Setting the password will remove the password.

If you know the password give it a try.
;-)

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22719611
;-)
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question