How to get userid permission for a specific folder via VBA

[albertmhleung]

How can I use the VBA Code to extract the userid's (not known) access right permission for a particular folder in Windows?

[zmbd]

I've ran across a few API calls that may be able to do this; however, I'm a tad out of my depth with them such that I hesitate to even offer a starting point.

Either Rabbit or ADezii might have a good place to start...

[Rabbit]

You can use a WMI object to query the DirectorySecurity Class.

http://msdn.microsoft.com/en-us/libr...ysecurity.aspx

If groups are used, you will then have to run an LDAP query to see if the user is in said group.

[zmbd]

And Rabbit just finished the first part of the:
http://bytes.com/topic/access/insigh...(WMI) Tutorial which should provide some further guidance.

@Rabbit:
The API calls I saw used the "advapi32.dll" however, they were very sparse on the actual usage and just provided some information about how to alter the security and one sort-a-kinda-alluded to the fact that with the user name/SID you could bitwise compare for security rights.

[Rabbit]

While I have used the WMI object in the past, I have not used it to query the DirectorySecurity. I am guessing that it uses whatever ID was used to add the permission. So if they used a domain user, then the domain user ID will show up there. If they used a security group, then the name of the security group would show up.