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

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 ?
LVL 1
benleicesterAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

map000Commented:
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
http://www.microsoft.com/windows2000/techinfo/planning/activedirectory/bulksteps.asp
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
WeHeCommented:
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"
0
benleicesterAuthor Commented:
Sorry WeHe intended to split the points but not sure how to do it.
0
WeHeCommented:
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.