Re: Useless User-level security wizard
- From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
- Date: Fri, 24 Jun 2005 16:48:46 -0400
You didn't answer Lynn's question, but I'll assume that that means that your
shortcut points to, say, your C: drive.
Your C: drive is NOT the C: drive for any user who's sharing your folder.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Leandro A." <LeandroA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6398C98C-2FD9-47AA-AC59-5776D835E72F@xxxxxxxxxxxxxxxx
> 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
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>
.
- References:
- Useless User-level security wizard
- From: Paul (ESI)
- Re: Useless User-level security wizard
- From: Lynn Trapp
- Re: Useless User-level security wizard
- From: Paul (ESI)
- Re: Useless User-level security wizard
- From: Lynn Trapp
- Re: Useless User-level security wizard
- From: Leandro A.
- Re: Useless User-level security wizard
- From: Lynn Trapp
- Re: Useless User-level security wizard
- From: Leandro A.
- Useless User-level security wizard
- Prev by Date: Re: Selecting Drive to export/import data
- Next by Date: Display data from key value
- Previous by thread: Re: Useless User-level security wizard
- Next by thread: Screen Resolution
- Index(es):
Relevant Pages
|
