Solved

Active directory linked as query via Access

Posted on 2014-01-22
2
1,264 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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

920 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

13 Experts available now in Live!

Get 1:1 Help Now