Using Workgroup Administrator ID to limit access to queries

  • Thread starter Thread starter Shane
  • Start date Start date
S

Shane

I use the workgroup administrator to grant access to a
particular database, and would like to be able to pull
the id that is entered when logging onto the workgroup
administrator to automatically restrict records in
queries. In other words, if I log in with the ID swithee
in workgroup administrator, I want to have only records
in certain tables with a field that displays only entries
with swithee.

Thanks!

Shane
 
Shane said:
I use the workgroup administrator to grant access to a
particular database, and would like to be able to pull
the id that is entered when logging onto the workgroup
administrator to automatically restrict records in
queries. In other words, if I log in with the ID swithee
in workgroup administrator, I want to have only records
in certain tables with a field that displays only entries
with swithee.
Click to expand...

The CurrentUser() function can be used to retrieve the currently logged in
user.

You would add a field to your table(s) to store this information. Your
query can then use a criteria of =CurrentUser() on this field.
 
thanks, this is a big help!
-----Original Message-----


The CurrentUser() function can be used to retrieve the currently logged in
user.

You would add a field to your table(s) to store this information. Your
query can then use a criteria of =CurrentUser() on this field.

--
Joan Wild
Microsoft Access MVP


.
Click to expand...
 
Back
Top