Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Security issue (97Sr2)

    I have a payroll system that is secured using access group security. This works great however I encountered another problem. In this payroll system, there are various menus to allow only the managers of that area to enter data. Example: SPA, General Operations, Youth Fitness. They is only one manager for the SPA and Youth Fitness but under the General there are several managers. How can I secure the "employees" so only their manager can view their records and not the other managers that use the same menu? Currently, all managers have access to all the employees in the General Category. This is not a good thing.

    Any suggestions greatly appreciated!

    Thanks,
    Deborah

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Security issue (97Sr2)

    Assuming that you have a field specifying the manager of an employee, and that this corresponds with the names the managers use to log into the database, you can create queries with CurrentUser() in the criteria line for the manager field, and use these queries as record source for the forms. If you use some kind of ManagerID, you can use an extra table to take care of the translation between login names and ManagerIDs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •