Possible to Create ODBC Link from Access to Active Directory?

[RobertIngles]

Hi all;

Just wondering if I can link data in AD to an Access DB. This would be used for querying and reporting only not changing or adding any data within AD. I have linked to SQL databases and Excel sheets before - is it as straight forward as that?

Thanks!

 

[lameid]

It has been a long time but I remember looking at AD data in Access... Not sure if I "linked" to it or used and ADO connection.... AD is an LDAP database so all you should need to do is look up the provider / connection string.

 

[PHV]

Have a look here:

http://www.connectionstrings.com/active-directory

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886