Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Setting up permissions....

Discussion in 'Information Technology' started by dcash45, Jul 28, 2006.

  1. dcash45

    dcash45
    Expand Collapse
    Guest

    Can someone please help with this problem? I want to know what is the best
    way or code to assign permission to different users in the database.
    Basically I want to enable or disenable buttons base one what user type it
    is. Also if I add another user type to the DB I want to be able to give that
    user type permission without going back into the code.

    Can anyone please help me out with this??

    Thank you,
     
  2. Loading...

    Similar Threads Forum Date
    General Great Production of English Songs and scene settings Videos Oct 11, 2012
    Hinduism Why is there Dancing in Bhajans or in Mandir Settings? Interfaith Dialogues Feb 18, 2011
    Personal Goal Setting. Why Set Goals? Business, Lifestyle & Leisure Oct 23, 2010
    Rise in Extremism or Rise in Hysteria? Canadian Sikhs Setting the Record Straight Hard Talk Apr 25, 2010
    Sikh News Badal invited to Pakistan for setting up of Nanak varsity (New Kerala) Breaking News Nov 23, 2009

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    dcash45 wrote:
    > Can someone please help with this problem? I want to know what is the
    > best way or code to assign permission to different users in the
    > database. Basically I want to enable or disenable buttons base one
    > what user type it is. Also if I add another user type to the DB I
    > want to be able to give that user type permission without going back
    > into the code.
    >
    > Can anyone please help me out with this??
    >
    > Thank you,


    I suggest you start by reading
    http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

    Access security is a great feature, but it is, by nature a complex product
    with a very steep learning curve. Properly used it offers very safe
    versatile protection and control. However a simple mistake can easily lock
    you out of your database, which might require the paid services of a
    professional to help you get back in.

    Practice on some copies to make sure you know what you are doing.

    --
    Joseph Meehan

    Dia duit
     
  4. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    You'll want to use User-Level Secuity to set up user accounts and
    permissions. Read the Secuity FAQ carefully:

    http://support.microsoft.com/support/access/content/secfaq.asp?

    Once you've implemented the user and group accounts, you may want to use my
    LockIt code to lock individual controls:

    http://www.datastrat.com/Code/LockIt.txt

    If there's just a few users, and all you want to control is one or 2 forms,
    you can get the login username from:

    http://www.mvps.org/access/api/api0008.htm

    and use that with the LockIt function.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "dcash45" <dcash45@discussions.microsoft.com> wrote in message
    news:2968112E-F6E7-40A5-A253-AF4E0338EC31@microsoft.com...
    > Can someone please help with this problem? I want to know what is the best
    > way or code to assign permission to different users in the database.
    > Basically I want to enable or disenable buttons base one what user type it
    > is. Also if I add another user type to the DB I want to be able to give
    > that
    > user type permission without going back into the code.
    >
    > Can anyone please help me out with this??
    >
    > Thank you,
    >
     

Share This Page