Using login ID as criteria in query

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?
 
M

Michel Walsh

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
 
Top