Access Access: user restricted querie

A

adidashawn6

Joined
Dec 8, 2010
Messages
3
Reaction score
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?
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
Excel Database Search for Dummies - Access 2003 vs Excel HELP! 0
Access Access Queries 0
Excel Access to Excel question 0
Access Creating Access databases for training record purposes 0
Access Access 2007 - Help - Please Read.... 0
How to make it so users see only certain records in a database 3
Access Combo Box / Report Help in MS Access 2003 0

Top