S
shiro
Hi All,
Is it possible to disable a control such as command button
to a certain user?.How to do that?
Is it possible to disable a control such as command button
to a certain user?.How to do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Joan Wild
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
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
S
shiro
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
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
J
Joan Wild
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.
S
shiro
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.
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.
J
Joan Wild
You need to give the users Read Data permission on the query. There is no Open/Run permission on a query.
S
shiro
I did Joan,
I have check the option read data for that user.
But still unable to open/run the query
You need to give the users Read Data permission on the query. There is no
Open/Run permission on a query.
I have check the option read data for that user.
But still unable to open/run the query
You need to give the users Read Data permission on the query. There is no
Open/Run permission on a query.
J
Joan Wild
What message do you get when you try to open the query as the user?
S
shiro
'Run Time Error 3033'
"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 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?
J
Joan Wild
Does it actually say 'query' or does it say the name of some query? You need to give as a minimum 'Read Data' permission on that query.
S
shiro
I did Joan,
I guve Read Data permission for all querys
in my db.
Does it actually say 'query' or does it say the name of some query? You
need to give as a minimum 'Read Data' permission on that query.
I guve Read Data permission for all querys
in my db.
Does it actually say 'query' or does it say the name of some query? You
need to give as a minimum 'Read Data' permission on that query.
J
Joan Wild
What is the actual name of the object given in the message in the single quotes?
S
shiro
'Monthly Sales Report'
'Pivot Excel' .
That they are.
What is the actual name of the object given in the message in the single
quotes?
'Pivot Excel' .
That they are.
What is the actual name of the object given in the message in the single
quotes?
J
Joan Wild
And what permissions do the users have on 'Monthly Sales Report' (I take it this is a report?) and 'Pivot Excel'?
S
shiro
Their ability are :
Read Design,Read Data,Insert Data,and Update Data
for both tables and querys.
And what permissions do the users have on 'Monthly Sales Report' (I take it
this is a report?) and 'Pivot Excel'?
Read Design,Read Data,Insert Data,and Update Data
for both tables and querys.
And what permissions do the users have on 'Monthly Sales Report' (I take it
this is a report?) and 'Pivot Excel'?
J
Joan Wild
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.
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.