Using login ID as criteria in query

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

I am trying to restrict the data that different users can
see by capturing the login ID and using it as criteria in
a query, but I can't find anything on this topic. Can
anyone tell me if this is possible and how to do it?
 
Sure.


You mean the Windows login? see http://www.mvps.org/access/api/api0008.htm

Else, if you use a secured database, you can relay on the CurrentUser
property. For database not specifically secured, the result is 'Admin' :

? Application.CurrentUser
Admin

so, under a secured network, the Windows login is probably more reliable, in
such cases.


Vanderghast, Access MVP
 
You must log in or register to reply here.

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

Use In() Expression as Query criteria with guts from Function 1
Access Dcount (multiple criteria) 3
Criteria in append querie 3
Acess query 4
Amazon Login Location Different 4
All-Record criteria in a query...hmmm 4
Entering criteria from form 2
query relelated to 2 combo boxes 2

Back
Top