Is it possible to import users from an Access Databse into Active Directory in Win Serv 2k3?

Hello,
We have ordered a server for about 20 computers for the press dpt in a school (Probably about 50 users will use these computers). We created a Microsoft Access Database with everyone's name, login name, temporary password, group they will be in, etc. so we can be organized, and also to be able to send out letters to everyone with their login information with mail merge...We were just going to type all of the users again into active directory when we get the server in, but is there any way to import the users from a database? Also, a little off topic, but we have set up an image that we are going to send to the other computers using ghost, and I've heard from somebody that the computer cannot be on the domain when you image it...Is that true? We just set the computer name to xxxxx and we were just going to go in and change it on each computer as it is imaged...Would there be any problem with this? Even if we just imaged 1-at-a-time and changed it there?

Thank you, Adam
LVL 1
ajschwAsked:
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.

WeHeCommented:
you can use tools like dsadd, dsmod or ldifde to manipulate the ad by script.
imaging has the problem of duplicate sid's.
a computer is not identified on his name, his SID (Security ID) is used for this.
this SID is generated while the computer is installed.
you must use a sidchanger before you use a imaged pc on your net. you will find them on google.
0
What90Commented:
Hi Adam,

There isn't a direct method for importing info to AD from Access. You could export the information to a .csv file and then use one of the command line tolls to import the file to AD, such as Ldifde http://support.microsoft.com/kb/237677 

With Ghost you shouldn't really ghost a machine while it's on the domain as it clones the SID and will cause problems if you have two identical SID on the same network. You can use the ghostwalker utility with ghost (ghstwalk) to change the sid, then add the machines to the domain.

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