Welcome to SPN

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

Sign Up Now!

Access 2000 security

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

  1. Ann

    Ann
    Expand Collapse
    Guest

    I'm fairly new to Access security and need some help. We have a network at
    our workplace with Access on a drive that is accessible by employees in two
    locations. I need to put security on one database to allow all employees
    access to it and then only a few employees access to a different database
    that is linked to the first database. The second database is used by the
    payroll department and the employee table in it has all the confidential
    information that should not be accessible by everyone. How to we divide the
    second database so that only employee name and not every other item
    associated with it can be linked to the first database that everyone can
    access?
     
  2. Loading...


  3. Joan Wild

    Joan Wild
    Expand Collapse
    Guest

    You've described a good reason to create a second table, that has a
    one-to-one relationship with the first.

    You'd put the confidential information in one, and just the employee name
    and other public information in the other.


    --
    Joan Wild
    Microsoft Access MVP

    Ann wrote:
    > I'm fairly new to Access security and need some help. We have a
    > network at our workplace with Access on a drive that is accessible by
    > employees in two locations. I need to put security on one database
    > to allow all employees access to it and then only a few employees
    > access to a different database that is linked to the first database.
    > The second database is used by the payroll department and the
    > employee table in it has all the confidential information that should
    > not be accessible by everyone. How to we divide the second database
    > so that only employee name and not every other item associated with
    > it can be linked to the first database that everyone can access?
     

Share This Page