Re: User Levels ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Is there a way to set user levels to buttons or specific forms with in
the same db?

Keep in mind if your using user level security in ms-access, it only narrows
down to rights for a whole form (and a whole table). So, rights don't extend
down to the field level.

You can however use code to "test" if a menu option or button is legal.

for example, I often disable a menu bar button based on a persons user level
security.

eg:

if IsInGroup(CurrentUser(),"InvoiceDeleteGroup") = true then


CommandBars("myCustomBar").Controls("AdminOptions").Controls("DeleteInvoice"
).Visible = True

end if

So, in the above, if the user is a member of the security group called
DeleteInvoice, then I enable the menu bar option that allows that feature.
You can do the same with a button on a form also.

eg:
me.MyButtionName.enabled = true


As mentioned you would replace the security group "DeleteInvoice" with the
name of the security group you created that users are to be a member of.


I should probably point out that user level security been discontinued for
access 2007 (it still works if you use the mdb format, but not for accDB
format. And, it not 100% clear in your last 3 posts if you are in fact using
ULS, or simply rolling your own security system.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx


.

Relevant Pages

  • Re: open exclusive for back end design
    ... >> password but i would like to secure the be with user level security.I ... you can open the backend and set the password. ... > frontend, and delete the links. ... > If you want to implement user level security on the backend, ...
    (microsoft.public.access.security)
  • Re: User security for ~120 organizations
    ... This is an appropriate use for User Level Security, ... populate the field in the tables with the value of CurrentUser() ... Should I try this with the user-level security wizard? ...
    (microsoft.public.access.security)
  • Re: A2007 Security
    ... enable the ShiftKey ByPass on my database? ... Create the bypass key property using the DDL argument so that only an ... administrator can change the setting (assumes you have set up user level ... security in A2000 prevented them from opening the tables or queries ...
    (comp.databases.ms-access)
  • Re: User Levels ?
    ... Keep in mind if your using user level security in ms-access, ... down to rights for a whole form. ... As mentioned you would replace the security group "DeleteInvoice" with the ...
    (microsoft.public.access.formscoding)
  • Re: open exclusive for back end design
    ... you can open the backend and set the password. ... frontend, and delete the links. ... If you want to implement user level security on the backend, ... Follow the steps outlined in the security FAQ. ...
    (microsoft.public.access.security)