How do I set Permissions in access 2010, for a key checkout Database?

[Darth21]

I want to set permissions in Access, how can I restrict an employee in my key checkout database from checking out keys that are not in their department. What kind of table do i create or is it visual basic coding?



Help, Brian

[June7]

Need to identify the user either by login procedure or grab their network ID. Have a table of users/employees with attributes for their permissions or department they are associated with. Once you know who is logged in can get info from table to restrict records by filtering according to their associated department or other permission criteria. Login procedure/form is common topic in forum. Search forum.