Discussion Locked

Cannot Access mdb data.

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hey, I have an access mdb that was given to me by the owner to get info out, but the ex-IS guy locked it when he left.

I have found what I believe is the matching mdw, and although I looked in it and found names, I still can't get into the mdb.
If I join the mdw, then I get completely locked out of Access. (Even on just going into access.)

All efforts at a password 'hack' have failed with useless passwords. (Some utilities say no password, others give me garbage.)

I believe the problem is I am not able to find the 'owner' of the database, and therefore can't get into it.

Anyone have any idea how to get into, or import tables from this pup?

Thanks in advance!!

7 replies

by cd

You didn't mention ACCESS version. On the other hand, I presume the database has user-group level passwords.

You could try the following:
1. If you know the former database owner name, you may be able to create the user in the current ACCESS installation.

or

2. Use the Access Password Recovery utility from ELCOMSOFT.com. For this case (.mdb created with an open password), the trial version recovers only the first 3 letters of the pass. Ask friends or the software company to get a password for a reg version.

Hope this helps.

by cviescas

Thanks, but a) I don't know the owner name, and b) the elcomsoft software told me there was no password. (I have the trial software, but no way to the registered version.)

If I can just find the owner's name, then the rest is history.

Thanks.
Charles....

by jonh

If the files are small enough and the data is not sensitive(private): you could attach the relevant files to an email to me and I will try to get at it with scripts or vb. Or not. You do have my curiosity up and so in the mean time I am going to lock an mdb and forget I own it and try to hack it.. thanks for the puzzle .. I will get back if anything positive pops...... HAGD (HAVE A GOOD DAY) JONH

by jonh

Something popped:
Access 97 uses a 14 byte password which is stored at hex location '42' with the following hex base (no password enterd) of..

"86 FB EC 37 5D 44 9C FA C6 5E 28 E6 13 B6"

this is use to exclusive OR (turn bits on and off) the password entered by the owner.

If you use a HEX editor (I downloaded WINHEX from winhex.com) you can do one of the following.
a) manually XOR (translate the password) and use it to open the database.
....or...
b) reset with the editor the 14bytes back to the base values to eliminate the password.

option (a) is good if you don't intend to use WINHEX enough to make it worth buying. You cannot save larger databases with the trial version. With this method your would open the database (exclusive) and use the manually translated password to get in and once you are in; use the "tools", and "reset password", menus to eliminate the password.

Using option (b).. buy WINHEX, hex edit the 14 bytes back to the base values, and save the modified version under a different name just in case you mess something up.....

I hope this helps .... HAGD (have a good day)
JONH...

by cviescas

Oh Man, talk about ugly! :-)

Actually, I ended up attacking the mdb via VB, and found that the mdb was *NOT* password protected, but the admin account was deleted and a single special user name as needed to access it. (My original suspicion.)

I ended up finding the trail in a simple utility that told me the user name. I then added the name to my system, opened the database and then removed the user restriction.

(But I *REALLY* like you answer better! :-)

Thanks.

This discussion is closed to new replies.