Getting username from active directory

[Guest]

Hi, i'm developing an access 2k aplication and i want the users log in to the
aplication with their usernames and passwords directly from active directory
so they don't have to type their usernames or passwords.

Thanks in advanced...

 

[Douglas J. Steele]

Can't be done. Access doesn't support the equivalent of SQL Server's Trusted
Connection.

It's easy to determine what their Windows Login ID is (see, for instance,
http://www.mvps.org/access/api/api0008.htm at "The Access Web") and, in
fact, you can "challenge" them to confirm their identity by providing their
network password (see
http://vbnet.mvps.org/code/network/acceptsecuritycontext.htm at Randy
Birch's VBNet), but you cannot incorporate that into Access User-Level
Security.