Welcome to SPN

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

Sign Up Now!

Security Features on Access Database

Discussion in 'Information Technology' started by jmarti45@gmail.com, Jul 28, 2006.

  1. jmarti45@gmail.com

    jmarti45@gmail.com
    Expand Collapse
    Guest

    Hello,
    I had quick question.

    I am buidling this database that I want anyone in my department to see
    certain query results and/or reports, but I dont want them to change
    anything I created. Is there any way to assign users to the database
    and then limited there actions. For example, I want my boss to login
    into the database and then change anything he wants, but than I want
    the A/R people to login into the database and see all the
    reports,queries, tables that I have but not allow them to change
    anything. Does anyone know whether that is possible?


    Juan
     
  2. Loading...


  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    Yes. It's called user level security and it's a LOT of trouble to get right
    in the first place then maintain.

    Microsoft has some information at:
    http://office.microsoft.com/en-us/assistance/HP030704101033.aspx
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "jmarti45@gmail.com" wrote:

    > Hello,
    > I had quick question.
    >
    > I am buidling this database that I want anyone in my department to see
    > certain query results and/or reports, but I dont want them to change
    > anything I created. Is there any way to assign users to the database
    > and then limited there actions. For example, I want my boss to login
    > into the database and then change anything he wants, but than I want
    > the A/R people to login into the database and see all the
    > reports,queries, tables that I have but not allow them to change
    > anything. Does anyone know whether that is possible?
    >
    >
    > Juan
    >
    >
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    jmarti45@gmail.com wrote:
    > Hello,
    > I had quick question.
    >
    > I am buidling this database that I want anyone in my department to see
    > certain query results and/or reports, but I dont want them to change
    > anything I created. Is there any way to assign users to the database
    > and then limited there actions. For example, I want my boss to login
    > into the database and then change anything he wants, but than I want
    > the A/R people to login into the database and see all the
    > reports,queries, tables that I have but not allow them to change
    > anything. Does anyone know whether that is possible?
    >
    >
    > Juan


    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
     

Share This Page