Useless User-level security wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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