Access: user restricted querie

Access Discussion in 'Microsoft Office' started by adidashawn6, Jan 6, 2011.

  1. adidashawn6

    adidashawn6

    Joined:
    Dec 8, 2010
    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. ukJAG

    Access Access and Access Database via the web?

    ukJAG, Mar 14, 2006, in forum: Microsoft Office
    Replies:
    3
    Views:
    336
    ukJAG
    Mar 14, 2006
  2. allisond

    Access MS Access 2000 to MS Access 2002 problem

    allisond, Mar 23, 2006, in forum: Microsoft Office
    Replies:
    0
    Views:
    271
    allisond
    Mar 23, 2006
  3. Milu

    Access User and Group Accounts in Access

    Milu, Jul 26, 2006, in forum: Microsoft Office
    Replies:
    0
    Views:
    242
  4. bigsteve

    Access Windows user area access problems

    bigsteve, Aug 16, 2006, in forum: Microsoft Office
    Replies:
    1
    Views:
    287
    muckshifter
    Aug 16, 2006
  5. whatevah

    Access User does not have access privileges

    whatevah, Jun 23, 2007, in forum: Microsoft Office
    Replies:
    1
    Views:
    2,841
    Techy
    Jun 25, 2007
  6. sawaan

    Access User Does not have access privileges

    sawaan, Mar 16, 2008, in forum: Microsoft Office
    Replies:
    0
    Views:
    346
    sawaan
    Mar 16, 2008
  7. cynthiacj

    Access Problems with Access 2007 and IME causing random access errors

    cynthiacj, Aug 8, 2009, in forum: Microsoft Office
    Replies:
    0
    Views:
    869
    cynthiacj
    Aug 8, 2009
  8. Keith Parker
    Replies:
    0
    Views:
    742
    Keith Parker
    Mar 10, 2010
Loading...