Re: Useless User-level security wizard

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Lynn,
I´m actually sharing a folder on my pc, it´s connected to the LAN here at my
work. So, I put the shortcut in the folder in my pc and share the folder.
Thanks.
--
Leandro A.


"Lynn Trapp" wrote:

> Leandro,
> What is the Target for the shortcut? If it is using drive letters and your
> users have different drive mappings than you do, then it will not work.
>
> --
> 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
>
>
>
> "Leandro A." <LeandroA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:EA1F4F1E-E76D-4665-98AA-90E9F987758B@xxxxxxxxxxxxxxxx
> > Hello Lynn,
> >
> > I have a little question for you. I acctually did the same thing you just
> > said on my database, and it worked fine. The problem is: I need to share
> > my
> > database on the network here at my work with other users (that is why I
> > need
> > this security login), but once I share it I get a big problem. Because if
> > a
> > share the shortcut that access creates, it does NOT work on other
> > computers.
> > And if I share the actual database the security login does NOT work either
> > and anybody can access it, doing it this way, for it to work, I would have
> > to
> > put the other computers on the domain that access creates and that
> > sometimes
> > doesn´t work either and if I put them on this domain, every time people
> > try
> > to use access they would have to enter their login, even if it is a
> > diferent
> > database.
> > Did you understand my problem?? I would be very greatful if you could help
> > me with this issue.
> >
> > Thank you.
> > --
> > Leandro A.
> >
> >
> > "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

  • Copy FE of DB when it is already open on the server
    ... I just recently changed my database that I'm running from a monolithic ... They click a shortcut, which used to lead to the old ... network (the master copy that Tony's program copies out to each user) ... by itself (as apposed to putting it in the same folder with the ...
    (comp.databases.ms-access)
  • Re: Lost ability to login to secure database
    ... First I moved the folder my database was in. ... original shortcut that the wizard made for me. ... to login and cannot open any of my secured databases. ...
    (microsoft.public.access.security)
  • Re: Could not useAdmin: file already in use.
    ... Lynn - absolutely correct; thank you! ... >Delete) to the FOLDER where the database is stored. ... It's for an employee in the User group of my ...
    (microsoft.public.access.security)
  • Re: Database Deployment
    ... I am not sure what you mean by UNC?The path to the folder ... >> security and having the shortcut on my desktop, ... >> move the database and shortcut to a shared folder on the ... >Put the backend and the mdw on the server. ...
    (microsoft.public.access.security)
  • Re: Useless User-level security wizard
    ... Your C: drive is NOT the C: drive for any user who's sharing your folder. ... I put the shortcut in the folder in my pc and share the folder. ... >>> database on the network here at my work with other users (that is why I ... >>> this security login), but once I share it I get a big problem. ...
    (microsoft.public.access.forms)