Solved Testing Accounts in AD Query

[pooldead]

I have a list of different AD accounts with certain permissions on our network. This list includes Users and Groups, however does not mention which is which. I have separate LDAP queries that I can run from Access to pull information based on whether the objectClass is User or Group. What I am wondering is: Is there a way to build a check in the code that basically says "If objectClass=User Then Run UserLdap Else Run GroupLdap"?

Or maybe take advantage of SELECT CASE?

Obviously the sample above is incredibly basic and not how I would actually set it up, but I wanted to describe the idea I had in my head.

 

[June7]

Access SQL does not recognize SELECT CASE. If by "code" you mean VBA then yes, can have conditional branching.

 

[pooldead]

Access SQL does not recognize SELECT CASE. If by "code" you mean VBA then yes, can have conditional branching.

My apologies. Yes, I did mean VBA (it's been a long day). I've used conditional branching before, but never with LDAP queries. Do you have an example of how I could set one up?

 

[theDBguy]

Hi. Not sure if this will help but thought I'd point you to it anyway. Cheers!

Code Snippets

 

[pooldead]

Hi. Not sure if this will help but thought I'd point you to it anyway. Cheers!

Code Snippets

That's close to what I was looking for. However, I won't know ahead of time which test the account fits into. I will have to run the account through, let's say, the objectClass=User test first. If the account pulls results, enter user information. If not, run the account through the objectClass=Group test, then enter group information. If the account isn't found in either, spit out a msgbox.

 

[arnelgp]

there is a thread somewhat similar.

URGENT - Retrieve Users From Active Directory Group, Access 2007

Dear all, As a beginner with Access, I have spent a lot of time searching this issue but cannot find an answer that works... So I am hoping that by posting my request, your great minds will definitely help me out...!!!! This is Really Really URGENT - From MS Access, I'm trying to Retrieve...

www.access-programmers.co.uk

 

[pooldead]

I figured this one out. I didn't realize I could modify my LDAP query to look only for the samAccountName, and not need to specify the objectClass at this stage. Thanks to everyone for your advice!

 

[theDBguy]

I figured this one out. I didn't realize I could modify my LDAP query to look only for the samAccountName, and not need to specify the objectClass at this stage. Thanks to everyone for your advice!

Congratulations! Glad to hear you got it sorted out. Good luck with your project.