Locked out of all Access DBs

20 Oct 2005 8:39 PM

Al

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

20 Oct 2005 8:47 PM

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

Show quoteHide quote

"Al" <A*@discussions.microsoft.com> wrote in message
news:388CD38A-87C9-4B3B-9FE5-50F6DA207331@microsoft.com...
>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

20 Oct 2005 8:56 PM

Al

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

Show quoteHide quote

"Lynn Trapp" wrote:

> 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
>
>
>
> "Al" <A*@discussions.microsoft.com> wrote in message
> news:388CD38A-87C9-4B3B-9FE5-50F6DA207331@microsoft.com...
> >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
>
>
>

20 Oct 2005 9:00 PM

Joan Wild

Al wrote:

> 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.

--
Joan Wild
Microsoft Access MVP