User Accounts

[Mikey_f]

I am sure this has been answered may times before but i cant seem to find it.
I have a db with just a table in and a db with the queries reports and the
form which i have made a mde from.
What i want to do is when a user opens the mde there is a pop up window
where they can select their name from a list and enter their password to get
access to the database.
What i also want to do is assign premissions to each user or type of user so
that some people (like a guest un-passworded account) have read only and a
few users being able to update records and only one admin account.
I would be greatfull if some-one would 'walk me' through this. I want the
users to accually have to login the database, do i need a table of users?
Can the security wizard do this as well and if so what do i do? tried it
once and got lost in what i was doing.
Just so you know i am not a programer (although seems i will need to learn)
so some of the programming term lose me .

 

[Rick B]

User-Level security is not easy to implement. You should make at least one
copy and then read the following links carefully. You must follow ALL the
steps IN ORDER.

--
Rick B
Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm

 

[Mikey_f]

Ok i have been able to secure the front end .mdb (I was using an mde but
wasnt allowed to run the security wizard on a .mde)
However when i try to secure the backend it locks the front end out?
Is it possible to secure both or do i have to leave the backend open??
Yes i know the answer is probably in the arcticle you told me to read but
cant see it for looking.
If it is just tell me where and i'll look at that.
Do i modify the .mdw to include the BE somehow?

 

[Joan Wild]

You just need to join the same workgroup that you used to secure the
frontend with. Or if you have a desktop shortcut, launch the frontend and
then use File, Open to open the backend and secure it. When prompted, do
not create a new workgroup file, but use existing.