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:
    2,819
    Madxgraphics
    Mar 28, 2009
  2. cynthiacj
    Replies:
    0
    Views:
    647
    cynthiacj
    Aug 8, 2009
  3. dannerz
    Replies:
    5
    Views:
    1,018
    Silverhazesurfer
    May 27, 2011
  4. jmjbear1011

    MS Access - Multi User Lock Issue

    jmjbear1011, Jan 23, 2013, in forum: General Software
    Replies:
    0
    Views:
    597
    jmjbear1011
    Jan 23, 2013
  5. Tamim
    Replies:
    1
    Views:
    1,021
    floppybootstomp
    Jan 24, 2013
Loading...

Share This Page