Query Active directory and populate access table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mayank - 06 Jul 2006 20:35 GMT

I want to be able to query active directory to populate one of the tables in
my access 2000 database. Is this something that can be done from within
access? Or, do I have to write an external program (eg. use .net
DirectoryServices classes) to do this? Can it be done in access 2003?

Thanks in Advance. :)

- Mayank

Reply to this Message

MGFoster - 06 Jul 2006 22:13 GMT

> I want to be able to query active directory to populate one of the tables in
> my access 2000 database. Is this something that can be done from within
> access? Or, do I have to write an external program (eg. use .net
> DirectoryServices classes) to do this? Can it be done in access 2003?

You can use ADO. Here is a URL that uses a different scripting language
to use ADO to access Active Directory:

http://tinyurl.com/kwfmg

You can probably use this script as a starting point. You'll have to
have an object model of the Active Directory classes.

If you Google "Active Directory" and VB or "Microsoft Access" you'll
probably find more sites.

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Reply to this Message