security a pian but getting closer

[Jim W]

When a user logs onto our computer network they must enter
a USER ID and Password is there a way that I can grab this and auto update access logon so that users do not have to enter twice? Big user complaint

any help would be great

Jim

 

[Fuga]

This is what I´ve picked up in a thread somewhere. I´ve never used it so I don´t know what it does, but there is a currentuser() function.

Fuga.

 

[Jim W]

Thank you for the help. I did try the code and could come up with the user name but not the password. Looking over the Access FAQ's on security it does say that you can set up 2 wrk groups
one used for updating or making changes and one that is secure using the system.mda wrk group. This way the user does not have to enter a password however, they donot have access to the backend nor can they make changes to the database. Looking at this option can anyone tell me how secure this is?

Thank you
Jim

 

[RebekahMN]

You could also use Environ("Username"). I used this and it captures whatever the pc login name is that user uses to log in. It's short and sweet...I don't know if it works on all operating systems or not though.

 

[Cosmos75]

You could also use Environ("Username"). I used this and it captures whatever the pc login name is that user uses to log in. It's short and sweet...I don't know if it works on all operating systems or not though.

Get User ID - Environ("username") vs CurrentUser()
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51196