Users permissions

[Mehvan]

Hello Everyone

I have a question about Users Permissions , How can I put special permissions for every users ?
I have three kinds of Users


1 = Manager
2 = Financial
3 = Administer

of course Manager can control every Forms , but others Users will have special permissions for using Forms

and also I want to show me user name on Forms : for Example ( When open to me Invoice Form ) there should has textbox , even I know who is using this Form
Permission.zip

[ranman256]

First the db is on the network, so users already have to login to windows.
In the db, I have a tUsers table, with userID, Name, and Level
USERID, FIRSTN, LASTN, LEVEL
bob12, bob smith, M (manager)
pam4, pam jones,"" (user)
xman, charles, xavier, F (financial)


when user opens the db, the main menu form will open and grab the userID.
Then lookup that persons rights in order to enable/disable controls.

sub form_load()
dim vUserID, vLevel

   vUserID =  Environ("Username")      'get userID

'get level from user table
   vLevel = Dlookup("[Level]","tUsers","[userID]='" & vUserID & "'")

'now, enable/disable items on form
   select case vLevel
         case "A"  'admin 
             'all is enabled

         case "U"  'normal user
             txtBox1.enabled = false
             txtManager.enabled = false

         case "M"  'manager
             txtBox1.enabled = false
   end select
end sub

[Mehvan]

thanks a lot for your help
I will try to use this code in my Project
but my work finished now , and I have a to go now
If I can use it without problem , and be good for my project , I will tell you and If I have a problem too , I will tell you too
thanks again for your help

[jwhite]

Relying on valid logins via Environ() function is a BAD idea! There are demos of using security like ranman suggests that have users login with their username and password. An example: http://www.utteraccess.com/forum/Sim...-t1961240.html

[Micron]

Relying on valid logins via Environ() function is a BAD idea! There are demos of using security like ranman suggests that have users login with their username and password. An example: http://www.utteraccess.com/forum/Sim...-t1961240.html

Why, pray tell? Not that I would use the Environ method anyway, but see no reason why the network login ID is never a good idea as you suggest.
Adding a login form and storing passwords adds a layer of design that serves little purpose IMHO. The link you provided even says that the sample given can be "easily circumvented". Even a password field provides little protection against anyone but the least experienced db user.

In my defense, how likely is it that people are sharing their network login credentials? Not very, I'd say. It's the way I would go.

[Mehvan]

thanks a lot
it was so useful , but I want to give me permission for users , When I want to set permission for users and say , Only I want this user can open this Invoice , and manager can control all Invoices , or it be same this Video too , it will be so useful : https://www.youtube.com/watch?v=bhQ9mRhks8g

[Micron]

To expand upon the solution given, the premise is that you have a user table (tblUsers) which has a field named UserLevel. Anyone who is an admin gets that user level value. Read only the same. Anything else in between is up to you, and you can add more fields if you want to have sub groups on the UserLevel value (you might want to give some supervisors access to certain forms but not to other forms).

If you have a form (switchboard) from which you are going to navigate to other forms or reports, you either enable or disable those buttons based on the user level value when you open that form. If you want, you can make the check again when opening those forms to ensure unauthorized people don't open them if you think it is possible for them to get into the Access nav pane (which you should set to not be visible when the db opens). The video only shows the interface that the designer created in order to manage the tblUsers UserLevel settings in the table, but they have based it on a form by form basis, which means you need a list of forms in a table. We're saying just assign Joe Smith the level of Admin (or whatever) and code to allow or not, the ability to click the switchboard buttons based on his level, rather than what his level is for every form.

[Mehvan]

thanks a lot for your advice
I already solved it and now it's working without problems
thanks again for your help .

[Micron]

Please mark your threads as solved if you're happy with the outcome.
Thanks.