Currentuser() feature (access 97 sr2)

Topic

New Reply

I have a database in Access 97 sr2 that I have secured using the currentuser feature in a query. This is great. The users can only view their associated employees and no other employees. I have one problem. I need for the administrator view all records. How can I do this and still user the currentuser feature.

Reply | Quote

Replies

Do you have CurrentUser() as criteria for a field in the query? If so, try replacing it with

Like IIf(CurrentUser()="TheBoss","*",CurrentUser())

where TheBoss is the name of the ‘administrator’ user.

Reply | Quote

THANK YOU! It worked wonderfully!!!

I can now sleep tonight.

Reply | Quote