Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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?
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page