Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can you limit who can run a report (w/o using Environ("username")

Status
Not open for further replies.

jeep2001

Programmer
Dec 15, 2005
134
US
I would like to limit who can run reports in my application. Currently, I used
If Environ("UserName") = "XXXXXXX" then
I print the report. This works fine except the user is currently working from home via VPN, and the pc she is using is Access 2002. She is getting an error message on the Environ keyword. Is there another way to accomplish this.
Thanks.
 
I don't really know how your database works, but maybe you could have a form onload that prompts you for username and password, associating it with a Dlookup to a certain keyword, and allowing that keyword access, if you get what I mean... I do this, but with the Environ("username")....

I think that is what you are looking for?!?
 
i used another way...password with a table..works ok
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top