Obtain User Names From Active Directory (1 Viewer)

[CharlesWh]

I'd like to be able to populate a table (TblUsers) with members of an Active Directory Group (DbUsers) and based on that then be able to write various bit of functionality.

The Active Directory bit is the aspect which I'm new to and could do with some principle advice or points to any links where there may be some examples of how to write it in Vba.

all advice most welcome & thanks.

(Access 2010)

 

[Banana]

Hi - I don't really think you need to have a table. You can just query the AD directly.

Have a look at those places:

http://accesssecurityblog.com
http://support.microsoft.com/kb/187529
http://www.serverwatch.com/tutorial...hrough-ADO-using-VB60-and-the-SQL-Dialect.htm
http://msdn.microsoft.com/en-us/library/Aa746471.aspx

The last one is probably the authoritative reference.

HTH.