Re: Disable control

You need to give the users Read Data permission on the query. There is no Open/Run permission on a query.

--
Joan Wild
Microsoft Access MVP
"shiro" <shiro@xxxxxxxx> wrote in message news:eyveFkYpHHA.4032@xxxxxxxxxxxxxxxxxxxxxxx
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?.


"Joan Wild" <jwild@xxxxxxxxxxxxxxxx> wrote in message
news:#6VU5KSpHHA.3252@xxxxxxxxxxxxxxxxxxxxxxx
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.

--
Joan Wild
Microsoft Access MVP
"shiro" <shiro@xxxxxxxx> wrote in message
news:uuZiWZMpHHA.1852@xxxxxxxxxxxxxxxxxxxxxxx
Thank's Joan,
But more question:
After implement user level security wizard,Why does
my user cannot open/run the query in the database?




"Joan Wild" <jwild@xxxxxxxxxxxxxxxx> wrote in message
news:#LNNm94oHHA.5084@xxxxxxxxxxxxxxxxxxxxxxx
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

--
Joan Wild
Microsoft Access MVP
"shiro" <shiro@xxxxxxxx> wrote in message
news:%23pNZkp3oHHA.4424@xxxxxxxxxxxxxxxxxxxxxxx
Hi All,
Is it possible to disable a control such as command button
to a certain user?.How to do that?






.