Solved

Active directory linked as query via Access

Posted on 2014-01-22
2
1,203 Views
Last Modified: 2014-01-27
I want to be able to link Active Directory via something like a pass-thru query so that I can retrieve full user name phone number, etc in real time so that if a new user is added to AD , I can get this information
0
Comment
Question by:shelbyinfotech
2 Comments
 
LVL 3

Accepted Solution

by:
0Doc earned 500 total points
Comment Utility
This link might help.  Its a vb script that reads user info from Active Directory and puts it into a CSV file.  The same concept could potentially be used to create an Access Table or Dataset.

http://www.wisesoft.co.uk/scripts/vbscript_extract_user_data_to_csv.aspx
0
 

Author Closing Comment

by:shelbyinfotech
Comment Utility
I followed it through and used pieces of the code
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Disabling the Directory Sync Service Account in Office 365 will stop directory synchronization from working.
Synchronize a new Active Directory domain with an existing Office 365 tenant
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now