I want to be able to automatically create Windows Server 2003 domain users via a live link to an access database

Posted on 2004-11-05
Last Modified: 2010-04-19
A slightly quirky one this.

I am putting in a 2003 network in a small school. In paralell to this project a student database is currently being created in Access (though not by me.)

I am no good with databases, so please forgive any ignorance in my question.

What we want to know if it is possible for fields in the database (ie. first name, last name, class etc.) to automatically create logons in Active Directory ? These would need to be linked live to the database (ODBC ?) so that if, for example, a student left, their logon would be removed / disabled. Also, group membership would need to be changed to reflect the relevant year and therefore, the approriate login script.

I personally can't see this ever working, but maybe that is the cynic in me. The database people seem to think it can be done.

Any suggestions ?
Question by:benleicester
    LVL 5

    Accepted Solution

    I don't know if you can do this, but for sure you can export the database and format it in a csv format and than use a tool to import the user in active direcotry
    ldifde it's an exemple of importing program
    LVL 11

    Expert Comment

    you can only use the database for quering with tools.
    if one student is deleted in your db, you must trigger a script, that will modify accounts in AD or in your local groups, depending if you have a domain or only a standalone server.
    for ad use tools like dsget, dsquery, dsmod to edit the objects.
    for a standalone server you can use "net localgroup" or "net user"
    LVL 1

    Author Comment

    Sorry WeHe intended to split the points but not sure how to do it.
    LVL 11

    Expert Comment


    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Preface Having the need * to contact many different companies with different infrastructures * do remote maintenance in their network required us to implement a more flexible routing solution. As RAS, PPTP, L2TP and VPN Client connections are no…
    I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    731 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

    17 Experts available now in Live!

    Get 1:1 Help Now