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?