Query Active directory and populate access table

[Mayank]

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

 

[MGFoster]

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.