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
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 ?