Using Active Directory Data in Access Tim Peterson 10/22/2008 4:20:05 PM I need to document permissions on my network and would like to link Access to Active Directory data so that I can build Access reports using Active Directory data. Is there any simple way to do this?

RE: Using Active Directory Data in Access Dale Fye 10/22/2008 7:30:01 PM Tim, Take a look at the following thread: LDAP Is it possible to read the Active Directory within an Access 10/17/2008 1:02 PM PST By: Crossh In: microsoft.public.access.modulesdaovba.ado -- HTH Dale Don''t forget to rate the post if it was helpful! email address is invalid Please reply to newsgroup only. "Tim Peterson" wrote: [Quoted Text] > I need to document permissions on my network and would like to link Access to > Active Directory data so that I can build Access reports using Active > Directory data. Is there any simple way to do this?

RE: Using Active Directory Data in Access Tim Peterson 10/22/2008 8:31:03 PM Thanks, Dale. Although I have a basic understanding of VBA, I was hoping that I could link to AD and see a tabular interface in Access as with ODBC. It seems that there is no easy way to query AD without first unsterstanding the AD data structure, and having extensive knowlege in VBA. I'm not familiar with the terms LDAP and ADO. Anyway, a seemingly simple idea is proving to be quite difficult. I have a lot of learning to do before I pursue this. Tim Peterson "Dale Fye" wrote: [Quoted Text] > Tim, > > Take a look at the following thread: > > LDAP Is it possible to read the Active Directory within an Access > 10/17/2008 1:02 PM PST > By: Crossh > In: microsoft.public.access.modulesdaovba.ado > > > -- > HTH > Dale > > Don''t forget to rate the post if it was helpful! > > email address is invalid > Please reply to newsgroup only. > > > > "Tim Peterson" wrote: > > > I need to document permissions on my network and would like to link Access to > > Active Directory data so that I can build Access reports using Active > > Directory data. Is there any simple way to do this?

Re: Using Active Directory Data in Access "david" <david[ at ]nospam.au> 10/23/2008 11:27:22 PM LDAP is Lightweight Directory Access Protocol, which is the protocol used with Active Directory. Sort of like ODBC is an Open DataBase Connectivity Protocol. Only ODBC is a SQL, Structure Query Language protocol, and LDAP isn't. Unfortunately, Access/JET does not have an LDAP plug-in, and MS does not have an ODBC LDAP driver. Both ODBC and DAO were depreciated by the time Microsoft got around to Active Directory. You might be able to buy an ODBC LDAP driver from some third party. I am not aware of one. Another approach might be to link the OLEDB object as a linked server in SQL Server, but Using Active Directory data without first understanding it is a little like using the registry without understanding it, only worse. Take a look at it with ADSIedit: it really is very hard to browse. Not that you would want to update it, or anything complex like that, but there is no published map. (david) "Tim Peterson" <TimPeterson[ at ]discussions.microsoft.com> wrote in message news:108F226F-170C-440E-B18B-B9BB98645042[ at ]microsoft.com... [Quoted Text] > Thanks, Dale. Although I have a basic understanding of VBA, I was hoping > that I could link to AD and see a tabular interface in Access as with > ODBC. > It seems that there is no easy way to query AD without first > unsterstanding > the AD data structure, and having extensive knowlege in VBA. I'm not > familiar with the terms LDAP and ADO. Anyway, a seemingly simple idea is > proving to be quite difficult. I have a lot of learning to do before I > pursue this. > > Tim Peterson > > "Dale Fye" wrote: > >> Tim, >> >> Take a look at the following thread: >> >> LDAP Is it possible to read the Active Directory within an Access >> 10/17/2008 1:02 PM PST >> By: Crossh >> In: microsoft.public.access.modulesdaovba.ado >> >> >> -- >> HTH >> Dale >> >> Don''t forget to rate the post if it was helpful! >> >> email address is invalid >> Please reply to newsgroup only. >> >> >> >> "Tim Peterson" wrote: >> >> > I need to document permissions on my network and would like to link >> > Access to >> > Active Directory data so that I can build Access reports using Active >> > Directory data. Is there any simple way to do this?

Re: Using Active Directory Data in Access "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 10/25/2008 4:59:59 AM Tim Peterson <TimPeterson[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Thanks, Dale. Although I have a basic understanding of VBA, I was hoping >that I could link to AD and see a tabular interface in Access as with ODBC. >It seems that there is no easy way to query AD without first unsterstanding >the AD data structure, and having extensive knowlege in VBA. I'm not >familiar with the terms LDAP and ADO. Anyway, a seemingly simple idea is >proving to be quite difficult. I have a lot of learning to do before I >pursue this. Yeah, I posted to that thread. It took me three or four days to find the relevant code that would work in Access. Then another day or two of solid heads down work to get everything running smoothly. And I like to think I'm a decent programmer and pretty good in Access. <smile> This is definitely in the advanced category. Best wishes. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/