CODEWITHSUNDEEP
ms-accessactive-directoryldap
wrichards0
wrichards0

Reputation: 187

Issue connecting Microsoft Access to Active Directory

I am trying to connect Active Directory to Microsoft Access 2010 using the LDAP string to import data into a database, which is queried by ASP. Even though I am looking to return contact details, i.e. firstname, lastname, email, phone number, etc. Due to not being sure what the field names I am looking for, I am just doing the following to begin with:

SELECT * FROM 'LDAP://OU=Users,DC=example,DC=internal'

and

SELECT * FROM 'LDAP://OU=Users, DC=example,DC=co,DC=uk'

I have, obviously, replaced the OU and DC values with dummy values. In both cases I am getting a syntax error, 'incorrect query string' and am struggling to figure out what I am doing wrong.

Upvotes: 0

Views: 1234

Answers (1)

Gene
Gene

Reputation: 392

There is some code in the code bank over at dbForums that might help you out.

http://www.dbforums.com/showthread.php?1605962-DBForums-Code-Bank&p=6296643#post6296643

Upvotes: 1

Related Questions