Login form with nt login

[hitesh_asrani_j]

Hi Guys,

Can someone help me creating a form that can take the username and password directly from the Windows NT login and password.

THanks and Regards,


hitesh_asrani_j

[June7]

This will grab user name from network: Environ("UserName") - yes, type it exactly as shown. Check this http://www.go4expert.com/forums/showthread.php?t=208

Why would you need password? I have doubts you can get it.

[boblarson]

You would not be able to get the user password. There are myriad reasons for that, but essentially the main one being that it would not be secure if anyone could just get that information.

[hitesh_asrani_j]

I am actually creating this for the team and it would be great if the teammate can only view there records and not others.. any help in this

[boblarson]

I am actually creating this for the team and it would be great if the teammate can only view there records and not others.. any help in this

You don't need their password for this. You could actually set it so that the logged in name can see their stuff only just by using the network login (as long as you are capturing that and including that in your tables). Then if a user is logged into a workstation, regardless of where they are, they can see only their stuff. But if you want an additional password for them to enter and not just based on the Windows login, then you would need to create that yourself and have a table store it (which isn't all that secure, but I've used some functions to encrypt and decrypt when needed).

[hitesh_asrani_j]

Yes,, Ok you can help me with that... It is ok if they just see what their name,.... and also one person who can see al

[June7]

The records would need a field that stores the user ID or a foreign key that links to the UsersInfo table. Access will not recognize Environ function so can't use directly in queries or controls. Use VBA Open event of a form that opens on default when project opens (Main Menu) and remains open to populate a textbox with this username or whatever ID value in the UserInfo table is the link for the other table. Then refer to this textbox as paramater input in queries. Or write a public function with the Environ code that can be called whenever wanted.