Home All Groups Group Topic Archive Search About

Locked Out, what did I do?

Author
8 Sep 2006 1:40 PM
bcemail
My first try at Access security, I used the wizard, and setup the passwords,
etc.  Now, when I try to open the DB, I get a message saying I don't have
permission, and to contact the Admin (me).  Where did I go wrong?  It never
prompts me to enter a password, and I'm not so sure about the creat/join
group function.  On the snapshot it gave me, I am listed under Admin.
Hope I didn't trash the whole thing.  Thanks for the help!

Author
8 Sep 2006 3:10 PM
Joan Wild
Sounds like a recent version (2002 or 2003), in which case the wizard
created a desktop shortcut to launch your secure mdb - use that instead.

You are likely trying to open the secure mdb via Windows Explorer, and since
you are joined by default to system.mdw, you get no login and have no
permissions.

Everything is working as it should.



--
Joan Wild
Microsoft Access MVP

bcemail wrote:
Show quoteHide quote
> My first try at Access security, I used the wizard, and setup the
> passwords, etc.  Now, when I try to open the DB, I get a message
> saying I don't have permission, and to contact the Admin (me).  Where
> did I go wrong?  It never prompts me to enter a password, and I'm not
> so sure about the creat/join group function.  On the snapshot it gave
> me, I am listed under Admin.
> Hope I didn't trash the whole thing.  Thanks for the help!
Author
8 Sep 2006 3:29 PM
bcemail
That did it!  Wish that it had told me that I had to use the shortcut.  I'm
treading a bit more carefully with security now...
Thanks!

Show quoteHide quote
"Joan Wild" wrote:

> Sounds like a recent version (2002 or 2003), in which case the wizard
> created a desktop shortcut to launch your secure mdb - use that instead.
>
> You are likely trying to open the secure mdb via Windows Explorer, and since
> you are joined by default to system.mdw, you get no login and have no
> permissions.
>
> Everything is working as it should.
>
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> bcemail wrote:
> > My first try at Access security, I used the wizard, and setup the
> > passwords, etc.  Now, when I try to open the DB, I get a message
> > saying I don't have permission, and to contact the Admin (me).  Where
> > did I go wrong?  It never prompts me to enter a password, and I'm not
> > so sure about the creat/join group function.  On the snapshot it gave
> > me, I am listed under Admin.
> > Hope I didn't trash the whole thing.  Thanks for the help!
>
>
>