Locked out of all Access DBs

[Guest]

I have been working with MS Access for over 10 years and a user just
contacted me with a very strange problem. She was messing with the security
on a split Access 2000 db and now cannot open any of the Access .mdb files on
her PC. When she tries to do anything within Access, including open a New
db, she is asked to enter a password. The logon box is definitely an Access
"Logon" box with her username entered in the "Name" box and the "Password"
box is waiting for a password. She claims that she did not set a password.
Here's the kicker, If she goes to another PC, the dbs open fine without any
mention of security.

Thank you in advance,
Al

 

[Lynn Trapp]

Have the user try to log on with a blank password. If that works, then have
her join the System.mdb file that shipped with Access. The reason she is
being prompted for a username and password is that the Admin user's password
has been set.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Thanks Lynn,

That's the first thing I had her try, but it didn't work. I'm assuming that
the next thing to try is uninstalling and reinstalling Access 2000 for her to
make the problem go away. Do you agree?

Thank you,
Al

 

[Joan Wild]

Thanks Lynn,

That's the first thing I had her try, but it didn't work. I'm
assuming that the next thing to try is uninstalling and reinstalling
Access 2000 for her to make the problem go away. Do you agree?

You don't need to go that drastic. Search her computer for all *.mdw files.
I'm guessing that she modified the standard system.mdw. Just replace it
with a system.mdw file from another computer.