Using the Active Directory from with Access

[Jonathan Blitz]

Is there a way to access the the Active Directory from within MSAccess?

Jonathan Blitz
AnyKey Limited
Israel

 

[John Nurick]

Hi Jonathan,

Anything that can be done with Visual Basic or VBScript can almost
always be done from within Access. Here's one place to start:
http://msdn.microsoft.com/library/d...-us/wmisdk/wmi/accessing_active_directory.asp

 

[Rob Oldfield]

The trouble is... that I still have yet to see a decent reference to what
you do within WMI. For example... one of the samples within that site
includes this...

select * from ds_computer where ds_cn='userName'","WQL",32

....and there's no references (that I've seen) to what on earth that is
doing. What's the WQL?... the 32?... how do I change the first select part
if I want default mail address from a user?

Not saying that you're wrong John, just that these methods are *incredibly*
badly supported by MS.

 

[Jonathan Blitz]

Yep.

Wondering if anyone has written any sort of wrapper code to make the access
simpler for mere mortals?

The trouble is... that I still have yet to see a decent reference to what
you do within WMI. For example... one of the samples within that site
includes this...

select * from ds_computer where ds_cn='userName'","WQL",32

...and there's no references (that I've seen) to what on earth that is
doing. What's the WQL?... the 32?... how do I change the first select part
if I want default mail address from a user?

Not saying that you're wrong John, just that these methods are *incredibly
badly supported by MS.

Hi Jonathan,

Anything that can be done with Visual Basic or VBScript can almost
always be done from within Access. Here's one place to start:

http://msdn.microsoft.com/library/d...-us/wmisdk/wmi/accessing_active_directory.asp