Results 1 to 5 of 5
  1. #1
    ajknoll23 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2014
    Posts
    2

    Incorporating active directory with Access

    Is there any way to incorporate AD into an Access database?

    We have multiple users with different rights and we are just looking for a way to get access to acknowledge the pass thru authentication.



    Is there any easy way to do this?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Would it be enough to just verify the user name and then grant priviliges to Access based on the Windows Login Environment?
    https://www.accessforums.net/code-re...ame-38386.html


    There are ways to get info from AD, but I am not thinking of the correct term for my search right now.

  3. #3
    ajknoll23 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2014
    Posts
    2
    Quote Originally Posted by ItsMe View Post
    Would it be enough to just verify the user name and then grant priviliges to Access based on the Windows Login Environment?
    https://www.accessforums.net/code-re...ame-38386.html


    There are ways to get info from AD, but I am not thinking of the correct term for my search right now.

    Thanks for the reply. I guess this is what we are trying to accomplish mostly but we are pretty confused on HOW to use this..

    http://www.accesssecurityblog.com/po...Directory.aspx

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Can you post some of the code from the functions from the DB? It may be enough to post the sections where objects are declared and instantiated. Maybe look for some ADO and post it here. Just something to jog my memory how to connect.

  5. #5
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    Well you can use the 'Calls' from AD to know the User, and that User's AD Security Group. so to keep things simple - a user opens the first form - and behind the scenes in that form's OnLoad event you trigger your vba calls and get 'Sam' 'Level XYZ'.....

    now its a blank slate in terms of database design what you do with that.... perhaps there are maybe some forms/reports that Level XYZ are allowed to open and others they are not... perhaps you want to append 'Sam' to every new record he/she enters so you know the source of data.... just a couple brief examples.. but you can call the data from AD which simply eliminates the need for a log in process in Access itself - - that's all that is accomplished (but can be very useful as people complain of having too many log ins)

    what style of security, data visibility is appropriate for your db is an entirely separate question and is part of the db design....

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 12-23-2016, 12:26 PM
  2. Replies: 1
    Last Post: 01-11-2014, 12:39 PM
  3. Replies: 5
    Last Post: 06-26-2013, 11:40 AM
  4. Active Directory & Access 2010: Importing Users
    By royarellano in forum Access
    Replies: 0
    Last Post: 12-08-2011, 02:32 AM
  5. access+Active directory
    By cpcp in forum Access
    Replies: 6
    Last Post: 11-15-2010, 02:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums