Is there an alternative method to using Environ("UserName") with Microsoft access
Posted on 2010-11-25
I have been using the Environ("UserName") funcion and it works great. It retuns the username of the current user logged into the system and I can use that name to perform different tasks.
Problem: I built an application for an organization that categorizes its users into different security classes. Power Users, laptop users, and desktop users.
The application works fine for the Power users and laptop users, but falls into error when desktop users are using the application.
What I found is that the deskstop users are restricted from accessing their C: drive and desktop and can only access the shared folders on the network and applications installed on the PC.
Is there another funciton or method I can use to capture the user name of a user with desktop privilages?