If you've implemented user level security, you can use the CurrentUser() function to grab their Access username. I would make the button invisible rather than disabled.
If CurrentUser() = 'shiro' then
Me.cmdWhatever.Visible = False
Else
Me.cmdWhatever.Visible = True
End If
You can also do this based on the group rather than just the user. There's code in the security FAQ you can use to determine if a user is a member of a group. http://support.microsoft.com/?id=207793
If you haven't used ULS, then you can grab the user's Windows login name and act on that. You'll find the code to retrieve this at http://www.mvps.org/access/api/api0008.htm
Thank's Joan,
But more question:
After implement user level security wizard,Why does
my user cannot open/run the query in the database?
If you've implemented user level security, you can use the CurrentUser()
function to grab their Access username. I would make the button invisible
rather than disabled.
If CurrentUser() = 'shiro' then
Me.cmdWhatever.Visible = False
Else
Me.cmdWhatever.Visible = True
End If
You can also do this based on the group rather than just the user. There's
code in the security FAQ you can use to determine if a user is a member of a
group. http://support.microsoft.com/?id=207793
If you haven't used ULS, then you can grab the user's Windows login name and
act on that. You'll find the code to retrieve this at http://www.mvps.org/access/api/api0008.htm
The user (or a group they are a member of) need at minimum Read Data permissions on the query. In addition you should set the Run permissions property of the query (View, Properties in design view) to Owner.
I've set the query's run permission to owner.but still get the same.
It just occured to action querys.
When I see the User/Group permission in security menu,
the option Open/Run of query is disabled.Any suggestion?.
The user (or a group they are a member of) need at minimum Read Data
permissions on the query. In addition you should set the Run permissions
property of the query (View, Properties in design view) to Owner.
"You on't have the necessary permission to use the 'query' object.
Have your system administrator or the person who created
this object estabilish the appropriate permission for you. "
What message do you get when you try to open the query as the user?
You have to remember that I can't see what you are seeing on screen.
You are getting a message that you don't have permission to 'some' object (be it a table/query/form/report). You need to double check the permissions on *that* object. Clearly the user does not have the right permissions.