Solved

UTILITIES FOR CRACKING .MDB PASSWORDS

Posted on 2001-07-17
17
556 Views
Last Modified: 2013-12-05
I have an .MDB containing historical records from 1997-1998 which I need to crack, but my predessor did not give me the password and cannot be called.  Anyone know of any good utilities which might be of help here?
0
Comment
Question by:Dreaming_Eagle
  • 4
  • 3
  • 3
  • +6
17 Comments
 
LVL 2

Expert Comment

by:Gudare
ID: 6291376
Considering the illegal nature of password crackers I doubt you'll be getting much assistance here, Dreaming Eagle, since I've seen most requests turned away in the past. Sorry.

-Craig
0
 
LVL 8

Expert Comment

by:DennisBorg
ID: 6291379
Are you referring to a Database Password or a User Password?

Which version of Access were these MDB's created in?
0
 
LVL 6

Expert Comment

by:cjswimmer
ID: 6291388
from a module in another database...run the following function:
Public Function GetMDBPassword(sDBName As String) As String
   Dim hFile As Integer
   Dim ich As Integer
   Dim stBuffer As String
   Dim rgbytRaw() As Byte
   Dim rgbytPassword() As Byte
   Dim rgbytNoPassword() As Byte
   
   rgbytNoPassword = ChrB(134) & ChrB(251) & ChrB(236) & ChrB(55) & ChrB(93) & _
                               ChrB(68) & ChrB(156) & ChrB(250) & ChrB(198) & ChrB(94) & _
                               ChrB(40) & ChrB(230) & ChrB(19) & ChrB(182) & ChrB(138) & _
                               ChrB(96) & ChrB(84) & ChrB(148) & ChrB(123) & ChrB(54)
                               
   hFile = FreeFile
   Open sDBName For Binary As #hFile
   Seek #hFile, 66 + 1
   rgbytRaw = InputB(20, #hFile)
   Close #hFile
   
   ReDim rgbytPassword(0 To 19)
   For ich = 0 To 19
       rgbytPassword(ich) = rgbytRaw(ich) Xor rgbytNoPassword(ich)
   Next ich
   stBuffer = StrConv(rgbytPassword, vbUnicode) & vbNullChar
   GetMDBPassword = Left$(stBuffer, InStr(1, stBuffer, vbNullChar, vbBinaryCompare) - 1)
End Function


I got this function from:
http://www.experts-exchange.com/jsp/qShow.jsp?qid=10544281
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 8

Expert Comment

by:DennisBorg
ID: 6291397
Are you referring to a Database Password or a User Password?

Which version of Access were these MDB's created in?
0
 

Author Comment

by:Dreaming_Eagle
ID: 6291454
CJ, your function returned two unprintable characters.  Maybe this is a '97 .mdb and the function is for the later version.

Regarding the legality, since we own the data, I rather doubt is there is any violoation in cracking it because someone did not leave the password behind.

My apologies for not stating so in the original question, but we are after an adminsitrator password, not a database password.  The database in question is looking to an .mdw file for the administrator password.  I really should have worded this question better.  
0
 
LVL 14

Expert Comment

by:mgrattan
ID: 6291605
Do you have Microsoft Visual Studio?  If so, there is a source code control program (Visual Source Safe) that comes with it.  

If you use Visual Source Safe to "check in" your database and then check it back out again, the security will be stripped from it.  You'll then be able to use the Security Wizard in Access if you want to re-create the security again.

See the following article:

http://support.microsoft.com/support/kb/articles/Q162/9/33.asp?LN=EN-US&SD=gn&FR=0&qry=use%20visual%20sourcesafe%20with%20Access%20database&rnk=23&src=DHCS_MSPSS_gn_SRCH&SPR=MSALL

Basically, you just need to check the database in to Visual Source Safe, delete the local copy, then create a new database from the copy that was checked-in to VSS.

0
 
LVL 6

Expert Comment

by:PsychoDazey
ID: 6291629
There are utilities for cracking into databases available.  I have seen them mentioned here in EE but have never used them myself. Try searching under the Keyword security or password.  Another place I have seen them is on http://www.downloads.com
If you dont have luck with either of those, Im sure CJswimmer can debug his code.  I work with him, he can code anything!
0
 

Author Comment

by:Dreaming_Eagle
ID: 6291872
I'm pooped tonight, but I'll look into both of these new solutions tomorrow at work if I get finished loading my new bad-ass $3,000 development workstation...:)  Thanks!  I *will* get back to you.
0
 
LVL 1

Accepted Solution

by:
frankylew earned 100 total points
ID: 6291990
///////////////////////////////
Easy Tracking
///////////////////////////////

Go www.download.com
and search 'access crack'
you will find the first one is suitable for you.


Cheers
0
 
LVL 1

Expert Comment

by:viperlin
ID: 6292250
i found some shareware ones about 4 months ago.  these were also older access 97 crackers.

i think i downloaded the cracker, it only showed the first 3 letters of the password so i got a crack for the cracker and then it worked like a charm.


0
 
LVL 9

Expert Comment

by:ornicar
ID: 6292253
Hi!

Try Access password recovery from Elcomsoft at:

http://www.elcomsoft.com/acpr.html

There is a free trial version.
0
 
LVL 2

Expert Comment

by:Gudare
ID: 6294371
And, Dreaming Eagle, once again I find my toes taste good when attempting to help someone. Good luck with your database. :) Sorry to everyone else who had helped this person.

-Craig
0
 
LVL 8

Expert Comment

by:DennisBorg
ID: 6294457
>My apologies for not stating so in the original question,
>but we are after an adminsitrator password,
>not a database password.  The database in question is
>looking to an .mdw file for the administrator
>password.  I really should have worded this question
>better.

Thanks for the clarification, Eagle.

Just to reword it, so others will understand what is meant by "the administrator password": you are needing to figure out what the password is for the user named "Admin"

Since it is the password for the Admin user that you are looking for, you might try putting a different System.mdw file in it's place. That is, you can try to use a System.mdw file which does not have a password assigned to the Admin user.

The PID for the Admin user would be the same, regardless of the System.mdw being used, which is why it is suggested that permissions be removed for user Admin when you are securing a database.

-Dennis Borg
0
 

Author Comment

by:Dreaming_Eagle
ID: 6295048
This demo version of this utility only shows you the first two letters of the passwords in an .MDW file, but the instant I saw the first two letters I knew which of the previous DB admin's passwords it was...

Thanks...the information in this .mdb is quite important to a lot of land owners in the SW who want to protect their water rights.
0
 
LVL 1

Expert Comment

by:frankylew
ID: 6296466
//////////////////////////////
Easy Tracking
//////////////////////////////

Dreaming Eagle,

I can help you to make the demo version of be fully workable to reveal all the digits if you wish, contact me if you would like to or post another question.

Cheers.
0
 

Author Comment

by:Dreaming_Eagle
ID: 6298138
Hey, thanks, Franky, but this pretty much cans this one.  We are moving the whole system in SQL Server, something which should be done in the next new months.  Truth be known, man, Access is such a quirky product I hope to have a long and productive career without ever seeing another major system which uses .mdb's on the backend, much less uses an Access front end to boot.  But I appreciate the offer and will circle back should this ever come up again.  Thanks to all of you.  I did not really have time to evaluate many of the answers.  I just grabbed the first one that worked and awarded the points.
0
 
LVL 1

Expert Comment

by:frankylew
ID: 6302554
D.Eagle,

I've been using Access 2000 as my VB API backend, and recently i found it quite slow for filtering records, am considrering switching to SQL Server, you have any comments ?

Cheers.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
unable to create table-based data macro in MS ACCESS 2013 11 25
Dlookup MSACCESS 5 25
Report with several filters - Issue with query? 3 23
Help with DoEvents 8 28
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

777 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