Re: Useless User-level security wizard

Tech-Archive recommends: Speed Up your PC by fixing your registry

Oh my gosh! That actually worked! Thank you so much! Gosh, Access can be so
weird!

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy


"Lynn Trapp" wrote:

> When you ran the wizard did it say anything about creating a shortcut for
> your desktop? If so, then you should use that to be able to log into the
> database.
>
> --
> 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
>
>
>
> "Paul (ESI)" <PaulESI@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:D1EA147D-E720-483E-9A73-0B1BCA448611@xxxxxxxxxxxxxxxx
> > 2002
> >
> > --
> > Have a nice day!
> >
> > ~Paul
> > Express Scripts,
> > Charting the future of pharmacy
> >
> >
> > "Lynn Trapp" wrote:
> >
> >> Paul,
> >> What version of Access are you using?
> >>
> >> --
> >> 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
> >>
> >>
> >>
> >> "Paul (ESI)" <PaulESI@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:8B7E4AB2-BC83-46BB-97E1-C53466E4E89D@xxxxxxxxxxxxxxxx
> >> >I was toying around with trying to create different users and give them
> >> > different permissions. This way our users cannot view and/or delete the
> >> > existing tables, forms, etc, but can only actually see the form as an
> >> > interface. I found the user-level security wizard and though "Cool! A
> >> > wizard
> >> > that will take care of it all for me." Not only that, but it creates a
> >> > backup
> >> > file in case there is any problem. Nifty huh? I thought so until I
> >> > actually
> >> > used the thing.
> >> >
> >> > First off, it didn't actually let you add any users as far as I could
> >> > see.
> >> > Seems like the only users are User and Admin. I created a different
> >> > user
> >> > name
> >> > and it just took the place of User.
> >> >
> >> > Secondly, when I opened the database, there is no way of logging in as
> >> > a
> >> > specific user, or logging out so you can log in as a different user.
> >> > Maybe
> >> > I'm crazy, but wouldn't it make sense for the wizard to set that up?
> >> > Not
> >> > only
> >> > that, but it only gave me the permissions of a user. I AM THE AUTHOR!!!
> >> >
> >> > After all that, it was supposed to be easy to remove the security BS
> >> > and
> >> > regain control of my database because of the backup file. Yeah right. I
> >> > didn't know how to do this, and the stupid report Access automatically
> >> > gave
> >> > me was absolutely no help. I had to just open the backup file in
> >> > Access,
> >> > copy
> >> > all the tables, forms, etc into a new database, and delete the database
> >> > Access ruined.
> >> >
> >> > Anybody know where I went wrong? How in the heck can I actually create
> >> > different user levels an actually allow somebody to login with a user
> >> > name
> >> > and password? If I am going to set up signons, I want to be able to
> >> > sign
> >> > myself on with full access to change, delete, modify whatever I want.
> >> > Any
> >> > help you can give would be appreciated. This all has me frustrated, to
> >> > say
> >> > the least.
> >> >
> >> > --
> >> > Have a nice day!
> >> >
> >> > ~Paul
> >> > Express Scripts,
> >> > Charting the future of pharmacy
> >>
> >>
> >>
>
>
>
.

Relevant Pages