>Is there an ActiveX control or some other way to have Access integrate with
>Active Directory? I'd like to show customized content depending on the users
>group membership in AD.
It's a b*tch and hard to work with.
The following posting end up being what I needed.
http://groups.google.ca/groups?hl=en&lr=lang_en&ie=UTF-8&safe=off&threadm=033401
c30554%24deccc7a0%24a401280a%40phx.gbl&rnum=3&prev=/groups%3Fhl%3Den%26ie%3DUTF-
8%26safe%3Doff%26q%3Dadsi%2Bsearch%2Borganizationalunit%26spell%3D1
IIRC after I got the logic working I discovered VB6 allowed you to run
LDAP queries within it natively. Rather than just being allowed to
use them in code. But that was over a year or two ago and my memory
is rather hazy.
I created the VB app so that a client in the construction field could
create folders by job and subfolders within the job. However those
sub folders would each have different security depending on the
persons function. That is foremen could see the drawings folder but
not the invoices folder.
I kept a page of notes when I was working on this topic. Below is
every link I found useful or not. Some may or may not be useful to
you.
Internet resources
Programmatically Set NTFS File System Folder Permissions
Enumerating Local Groups and Descriptions with NetLocalGroupEnum
Pasted from
<http://vbnet.mvps.org/code/network/netlocalgroupenumdesc.htm>
Enumerating Members of a Group with NetLocalGroupGetMembers
Pasted from
<http://vbnet.mvps.org/code/network/netgocalgroupgetmembers.htm>
Xcacls.exe
Pasted from
<http://support.microsoft.com/default.aspx?scid=KB;EN-US;825751>
How To Use High-Level Access Control APIs from Visual Basic
Pasted from
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;295004>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/iadsg
roup.asp
ldap
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/a
nch_activediradsi.asp
Active Directory Service Interfaces Quick-start Tutorials
<http://msdn.microsoft.com/library/en-us/adsi/adsi/adsi_quick-start_tutorials.asp
?frame=true>
IADsAccessControlEntry
<http://msdn.microsoft.com/library/en-us/adsi/adsi/iadsaccesscontrolentry.asp?fra
me=true>
An ADSI Primer, Part 11: More on Scripting Permissions and Auditing
(Windows Scripting though)
<http://www.windowsitpro.com/WindowsScripting/Article/ArticleID/7456/7456.html>
HOWTO: Use ADsSecurity.dll to Remotely Add Local Account ACEs to an
NTFS File
<http://support.microsoft.com/default.aspx?scid=kb;en-us;Q285998>
How To Use ADSI to Set Automatic Inheritance of File/Folder
Permissions
Pasted from <http://support.microsoft.com/kb/266461/EN-US/>
http://groups.google.ca/groups?q=group+dacl+security+permissions+group:*vb*&hl=e
n&lr=lang_en&safe=off&selm=3A42D078.3ED7F611%40hotmail.com&rnum=10
Various constants are at the following:
http://www.serverwatch.com/tutorials/article.php/1476721
Security and Access Rights
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/base/fil
e_security_and_access_rights.asp
How To Use ADSI to Set Automatic Inheritance of File/Folder
Permissions
<http://support.microsoft.com/default.aspx?scid=kb;en-us;266461>
VBScript recursive changing of subfolders
IADsAccessControlEntry Property Methods
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/iadsa
ccesscontrolentry_property_methods.asp
HOWTO: Use ADsSecurity.dll to Remotely Add Local Account ACEs to an
NTFS File
<http://support.microsoft.com/default.aspx?scid=kb;en-us;Q285998>
How To Use ADsSecurity.dll to Add an Access Control Entry to an NTFS
Folder
<http://support.microsoft.com/default.aspx?scid=kb;en-us;Q279682>
Tony

Signature
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 Toews [MVP] - 02 Mar 2007 23:16 GMT
>>Is there an ActiveX control or some other way to have Access integrate with
>>Active Directory? I'd like to show customized content depending on the users
[quoted text clipped - 4 lines]
>The following posting end up being what I needed.
>http://groups.google.ca/groups?hl=en&lr=lang_en&ie=UTF-8&safe=off&threadm=033401
c30554%24deccc7a0%24a401280a%40phx.gbl&rnum=3&prev=/groups%3Fhl%3Den%26ie%3DUTF-
8%26safe%3Doff%26q%3Dadsi%2Bsearch%2Borganizationalunit%26spell%3D1
Also Richard is a fellow MVP and has lots of sample code at his
website. It's VBScript but should still work reasonably well.
http://www.rlmueller.net/products.htm
Tony

Signature
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
David W. Fenton - 05 Mar 2007 22:49 GMT
> I kept a page of notes when I was working on this topic. Below
> is every link I found useful or not. Some may or may not be
> useful to you.
Could you put those up on your website, please? :)
One question: did you find as way to use AD Organizational Units?
That's the one area that I could never figure out in the code I
tried, and it's the one thing I needed!

Signature
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Tony Toews [MVP] - 06 Mar 2007 17:48 GMT
>> I kept a page of notes when I was working on this topic. Below
>> is every link I found useful or not. Some may or may not be
>> useful to you.
>
>Could you put those up on your website, please? :)
But, but, but that would imply I'd have to go back to all those links
and figure out what was useful and what wasn't. <smile>
Tony

Signature
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
David W. Fenton - 05 Mar 2007 22:51 GMT
> I kept a page of notes when I was working on this topic. Below
> is every link I found useful or not. Some may or may not be
> useful to you.
Never mind my previous OU question -- the Google post you pointed to
takes care of it. An LDAP query is *much* simpler than any of the
code I've ever seen explaining how to do that stuff.

Signature
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Tony Toews [MVP] - 06 Mar 2007 17:49 GMT
>Never mind my previous OU question -- the Google post you pointed to
>takes care of it.
Glad to hear it. I'dve had to spend an hour figuring out what was
what all over again.
Tony

Signature
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