I lost the password for a file in ACCESS

G

Gilbert

How can recover the password for a database I created in ACCESS 2002.
Now I can't do shit.
Please help.
Microsoft was not able or did not want to help.
 
D

Dirk Goldgar

Gilbert said:
How can recover the password for a database I created in ACCESS 2002.
Now I can't do [anything].
Please help.
Microsoft was not able or did not want to help.

Is this is a database password you're talking about, or the password for
a user in user-level security (also called workgroup security)? If the
former, google for password-cracking programs -- they're out there.
Access 97's database password was trivially easy to crack, but it got
harder in later versions.

If it's the password for user-level security, then it's not so easy,
unless -- and this is quite possible -- the database wasn't properly
secured. It's worth checking to see if you can get in just by using the
default SYSTEM.MDW file that was installed with Access, and specifying
the Admin user with no password.
 
K

kabaka

Gilbert said:
How can recover the password for a database I created in ACCESS 2002.
Now I can't do ****.


As a rather amateur programmer, I realize the frustrations involved in
learning a sophisticated program such as Access; however, could I ask that
you not use expletives in your posting as such language may offend others
(myself included).

As for your password problem, I personally can't help but I have read
several posts that address that problem (Try searching in the Security
section).

Good Luck
 
L

Larry Linson

Gilbert said:
How can recover the password for a database I created in ACCESS 2002.
Now I can't do shit.
Please help.
Microsoft was not able or did not want to help.

There are third-party products of various quality for "password recovery".
You should be able to find some with a little Googling. It is not
Microsoft's job, nor in their interest, to make it easy to "crack" security
on an Access database. In fact, they are constantly bombarded with requests
to improve security.

My advice for the future is to make careful records of your passwords,
whether overall database passwords or user-and-group-level security.

One approach used by some developers is that the development copy is
unsecured, and they secure it each time a new version is released to the
users.

Larry Linson
Microsoft Access MVP
 
Top