Querying Active Directory

[Djbell]

Hi All

I use Access 2007 and I am also a domain Admin.

I have created a database that basically takes a file created from a program called dumpsec and restructures it into a readable table.

I also have 2 other tables, 1 called Users and 1 called groups, at the moment I manually fill the information in, the Users table is basically the Username and Fullname of all users in my domain. The groups tables is a list of groups and then all users in that group.

The main problem I have is that changes within groups occur regulary and this database can become a headache to administer, is there any way I can create queries instead to get the information i need directly from AD?

Cheers

Djbell

 

[jsteph]

There's a 3rd party tool I use, I think it's ADSTools, it gives an OLE interface to AD, you can query, parse through recordsets, update, etc.
--Jim

 

[Djbell]

Hi Jsteph

All ADSTools is an Alternate Data Stream Editor. I cant figure out how you can use this to Query Active Directory.

Cheers

Djbell

 

[jsteph]

djbell,
I may have mistyped that, I'll try to find the right spelling, it might just be ADtools or something. Either way, I used to to directly query AD data.

With this, I could write SQL and recieve recordsets that contained the entire set of AD info, from the top of the tree to just a single user, and I could edit their info.

I used it to synchronize AD with our payroll system's address and phone# info (which was the master data) so that AD always had the latest address and phone # for the user, because we used another tool for a company-wide phone book, and this tool read AD.
--Jim

 

[jsteph]

Djbell,
Search google for iadstools.dll, there should be some download sites.

That's the actual dll I use in the VB programs. It gives programatic read/write access to the Active Directory structure.
--Jim