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

[jeep2001]

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.

 

[ItIsHardToProgram]

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

 

[jeep2001]

i used another way...password with a table..works ok

 

[ItIsHardToProgram]

I guess that is another way.