VBA Access security role

(0) Share

Report

Posted on by Community Member

hi all,

using VBA, is it possible to get details about security roles and tasks about the current user. I tried Userinfo object, it provides basic information the user. Is there any alternative way for this. Any reply will be highly appreciated.

thanks in advance,

arun.

*This post is locked for comments

All responses (2)

Answers (0)

Sort by

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

You can query the following table...
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
Copy link

Link copied!

I believe you would consider the method provided by Mr. David, to open a connection string with the database, retrieve the required security roles and tasks and close the connection. Check the following reference, it me be useful:

Using VBA

On the other hand, to get this done, I would not recommend reinventing the wheel, the Support Debugging Tool already has already solved this out.

Check the following reference:

How to identify the security roles and tasks using Support Debugging Tool.

Hope this helps,