Useless User-level security wizard

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
 
G

Guest

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
 
G

Guest

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.
 
G

Guest

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.
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User-Level Security 1
User Level Security Enquiry 1
User-Level Security Wizard 2
user level security 1
User-Level Security Wizard 3
Wise to set up user level security for a multi FE MDB ?? 9
user level security wizard 7
Form level security 5

Top