Solved

Active directory linked as query via Access

Posted on 2014-01-22
2
1,465 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
ID: 39801358
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
ID: 39812217
I followed it through and used pieces of the code
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

749 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