Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / ActiveX Controls / March 2007

Tip: Looking for answers? Try searching our database.

Active Directory integration in Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
archuleta37 - 01 Mar 2007 18:56 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
group membership in AD.

Any help is much appreciated.
Marc
Tony Toews [MVP] - 02 Mar 2007 23:05 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
>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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.