Re: How do I pull data from our AD to input into an access database

[Michel Walsh]

Hi,

I am not sure I understand.

CurDir

returns the current directory used by Access.

Hoping it may help,
Vanderghast, Access MVP

"Bruce" <Br...@discussions.microsoft.com> wrote in message
news:88EC439D-6BC0-4D9C...@microsoft.com...
>I have a database in access that I use to asign computer netbios names..I
> need to now access the active directory for the information...how can I do
> this?

[Alex White MCDBA MCSE]

What I you trying to retrieve, all the registered computers on the network?

ADSI is what you need

http://www.freevbcode.com/ShowCode.asp?ID=703

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

[McLean@discussions.microsoft.com Bruce McLean]

Hi Michel
What I am trying to do is thru AD (active directory) get a list of the users
and add the data ie name of the user and department they work in, to my
database then from this data I generate a computer name as in username joe
blow department finance so his computer name would be jbfin-001 or something
like that..
Thanks for the help

[Michel Walsh]

Hi,

I see. Was confused with a current, active, directory, while it was the
Active Directory. I would have use WMI, but the solution proposed by Alex
White seems more direct.

Vanderghast, Access MVP

"Bruce McLean" <Bruce McL...@discussions.microsoft.com> wrote in message
news:25B5C060-8618-403A...@microsoft.com...

> Hi Michel
> What I am trying to do is thru AD (active directory) get a list of the
> users
> and add the data ie name of the user and department they work in, to my
> database then from this data I generate a computer name as in username joe
> blow department finance so his computer name would be jbfin-001 or
> something
> like that..
> Thanks for the help
>