Using Workgroup Administrator ID to limit access to queries

[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

 

[Joan Wild]

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.

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.

 

[Shane]

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


.