Re: Disable control

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?




.