Link With Active Directory

[bunji]

Hi All

I have a small Help Desk db with tables that contain computer spec and user information. But I already have all this information in Active Directory and it seems pointless entering the information twice.

Is there any way i can get the database to lookup the information from Active directory i have no idea where to start.

Thanks

 

[The_Doc_Man]

Presuming you can get past the rather strict security constraints placed on the Active Directory repository, you can look up anything you want, since Active Directory is a true DB based on the MS Extensible Storage Engine. If you can activate ESE, you've got half the battle won right there.

Visit the MS site to find the following for starting points.

Knowledge base article: Q196464

Look up white papers from MS: "Guide to Active Directory Design" and "Active Directory Architecture" - both at http://www.microsoft.com/technet/prodtecnol/ad/windows2000 but in different sub-paths from there. Should be able to find references via searching MS within the Technet site, I would think.

You will probably also have to reference some .DLL files as external sources of subroutines, so look up stuff in the Access Help files for how to set up external call references. There are a few examples, as I recall. You might look up the topic of calling Win32API from Access because that might be the actual header for the topic.