I am working with Active Directory.
I have some data in my access database.
i need to compare these data with Active directory's sAMAccountname.
I used the SQL statement to pull AD information into a recordset.
But unable to compare with access table.
If the recordset from AD is in a temptable then it may be possible to compare with my existing Table.
So am i going in the right direction?
If yes,How can i create table with the recordset(which i pull from Active directory).
Please provide me some (VBA,access 2003) code.
My SQL code is:
Expand|Select|Wrap|Line Numbers
- objCommand.CommandText = "SELECT sAMAccountName " & _
- "FROM 'LDAP://My AD Path"
- 'Debug.Print objCommand.CommandText
- Set rsADSAMAccountName = objCommand.Execute
- 'Debug.Print rsADSAMAccountName.GetString
- strSQL = "CREATE TABLE tempTbl(sAMAccountName varchar(255) NULL)"
Thank You SoMuch Sir In advance.