Welcome to SPN

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

Sign Up Now!

Security Level

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

Tags:
  1. SF

    SF
    Expand Collapse
    Guest

    Hi,

    I have develop a database now in user by 3 departments. This database work
    fine except it does not have any security level setting. The management
    asked me to add this feature for example setting up 3 groups (users,
    department head and Head of orgnazation). Users can do certain thing where
    as Department Head can do certain thing that Users cannot do...

    I cannot find a way to setup this security level. Could somebody give some
    ideas. Does this related to Access Security (Log on) or it is a separate
    setup?

    SF
     
  2. Loading...


  3. Martin

    Martin
    Expand Collapse
    Guest

    You can use the User level security wizard, to set this up,

    More information can be found here:

    http://office.microsoft.com/en-us/assistance/HA011381101033.aspx

    and the following pages, by clicking next at the bottom of that page

    Hope this helps

    martin


    "SF" wrote:

    > Hi,
    >
    > I have develop a database now in user by 3 departments. This database work
    > fine except it does not have any security level setting. The management
    > asked me to add this feature for example setting up 3 groups (users,
    > department head and Head of orgnazation). Users can do certain thing where
    > as Department Head can do certain thing that Users cannot do...
    >
    > I cannot find a way to setup this security level. Could somebody give some
    > ideas. Does this related to Access Security (Log on) or it is a separate
    > setup?
    >
    > SF
    >
    >
    >
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    SF wrote:
    > Hi,
    >
    > I have develop a database now in user by 3 departments. This database
    > work fine except it does not have any security level setting. The
    > management asked me to add this feature for example setting up 3
    > groups (users, department head and Head of orgnazation). Users can do
    > certain thing where as Department Head can do certain thing that
    > Users cannot do...
    >
    > I cannot find a way to setup this security level. Could somebody give
    > some ideas. Does this related to Access Security (Log on) or it is a
    > separate setup?
    >
    > SF


    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
     
  5. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    You will want to use Access User-level security. A security faq is available
    at:

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

    Read it carefully several times. Proper security is complex and you could
    easily lock yourself out. When first setting everything up, make sure that
    you have a backup for everything.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "SF" <socfund@online.com.kh> wrote in message
    news:OSiMcEMnGHA.4636@TK2MSFTNGP03.phx.gbl...
    > Hi,
    >
    > I have develop a database now in user by 3 departments. This database work
    > fine except it does not have any security level setting. The management
    > asked me to add this feature for example setting up 3 groups (users,
    > department head and Head of orgnazation). Users can do certain thing where
    > as Department Head can do certain thing that Users cannot do...
    >
    > I cannot find a way to setup this security level. Could somebody give some
    > ideas. Does this related to Access Security (Log on) or it is a separate
    > setup?
    >
    > SF
    >
    >
     
  6. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    In addition to the advice you have received from others, check out Access MVP
    Lynn Trapp's page:

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

    In particular, check out the link for "The 10 Steps Summarized".


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "SF" wrote:

    > Hi,
    >
    > I have develop a database now in user by 3 departments. This database work
    > fine except it does not have any security level setting. The management
    > asked me to add this feature for example setting up 3 groups (users,
    > department head and Head of orgnazation). Users can do certain thing where
    > as Department Head can do certain thing that Users cannot do...
    >
    > I cannot find a way to setup this security level. Could somebody give some
    > ideas. Does this related to Access Security (Log on) or it is a separate
    > setup?
    >
    > SF
     

Share This Page