Access: user restricted querie

Discussion in 'General Software' started by adidashawn6, Jan 6, 2011.

  1. adidashawn6

    adidashawn6

    Joined:
    Dec 8, 2010
    Messages:
    3
    Likes Received:
    0
    I have a database that I am going to place user-level security. The reports that are going to be available need to be restricted to the user that is logged in and running the report. For example, there is a table that lists the managers and the employees that report directly to these managers. I need the criteria of the query that the report is based on to look at the user information used to log into the database, and use this user information to only pull the direct reports for that manager into the report. Can anyone help with this?
     
    adidashawn6, Jan 6, 2011
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Dramaqueen

    Google End User Licence Agreement

    Dramaqueen, Mar 27, 2009, in forum: General Software
    Replies:
    6
    Views:
    3,197
    Madxgraphics
    Mar 28, 2009
  2. cynthiacj
    Replies:
    0
    Views:
    863
    cynthiacj
    Aug 8, 2009
  3. Monica

    How to update user manual online?

    Monica, Dec 7, 2009, in forum: General Software
    Replies:
    1
    Views:
    494
    floppybootstomp
    Dec 7, 2009
  4. robinkiefer

    HELP! End User License Agreement Pop Up

    robinkiefer, Feb 22, 2010, in forum: General Software
    Replies:
    4
    Views:
    737
    robinkiefer
    Feb 23, 2010
  5. dannerz
    Replies:
    5
    Views:
    1,249
    Silverhazesurfer
    May 27, 2011
  6. jmjbear1011

    MS Access - Multi User Lock Issue

    jmjbear1011, Jan 23, 2013, in forum: General Software
    Replies:
    0
    Views:
    742
    jmjbear1011
    Jan 23, 2013
  7. Tamim
    Replies:
    1
    Views:
    1,104
    floppybootstomp
    Jan 24, 2013
  8. Dana
    Replies:
    0
    Views:
    196
Loading...