General discussion
December 17, 2001 at 11:44 PM
kyu

Auto-create users from MS-Access

by kyu . Updated 24 years, 8 months ago

I’m looking for an elegant way to get new users imported into Windows 2000 Advanced Server’s Active Directory from MS-Access 2000. Ideally, the process should be initiated by clicking on an executable desktop icon.

CSVDE.EXE isn’t exactly what Iam looking for, though.

The MS-Access table contains four relevant fields among others: firstname, lastname, password and add. The add field contains either a Yes or No. Yes means, “go ahead” and create the new user.

The new user name in Active Directory uses one letter from the firstname field and the full lastname field. Password is “password”, as default.

As an example, for Jack Smith, the firstname field will contain “Jack” and the lastname field will contain “Smith”. This processshould automatically create a new user in Active Directory as “jsmith” with “password” as the log-on password.

I’d appreciate your help. Url links, articles, direct instructions, etc., are all welcome.

Many thanks.

This discussion is locked

All Comments