Access 2000 security

[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?

 

[Joan Wild]

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.