Re: Disable control

And what permissions do the users have on 'Monthly Sales Report' (I take it this is a report?) and 'Pivot Excel'?

--
Joan Wild
Microsoft Access MVP
"shiro" <shiro@xxxxxxxx> wrote in message news:eatGQOkqHHA.4268@xxxxxxxxxxxxxxxxxxxxxxx
'Monthly Sales Report'
'Pivot Excel' .
That they are.

"Joan Wild" <jwild@xxxxxxxxxxxxxxxx> wrote in message
news:OBXNqhEqHHA.3892@xxxxxxxxxxxxxxxxxxxxxxx
What is the actual name of the object given in the message in the single
quotes?

--
Joan Wild
Microsoft Access MVP
"shiro" <shiro@xxxxxxxx> wrote in message
news:%23ZgJvT%23pHHA.4772@xxxxxxxxxxxxxxxxxxxxxxx
I did Joan,
I guve Read Data permission for all querys
in my db.


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

--
Joan Wild
Microsoft Access MVP
"shiro" <shiro@xxxxxxxx> wrote in message
news:%23t$eV%23zpHHA.4632@xxxxxxxxxxxxxxxxxxxxxxx
'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. "


"Joan Wild" <jwild@xxxxxxxxxxxxxxxx> wrote in message
news:Ok6rB9qpHHA.4212@xxxxxxxxxxxxxxxxxxxxxxx
What message do you get when you try to open the query as the user?

--
Joan Wild
Microsoft Access MVP
"shiro" <shiro@xxxxxxxx> wrote in message
news:eQUlMtkpHHA.3948@xxxxxxxxxxxxxxxxxxxxxxx
I did Joan,
I have check the option read data for that user.
But still unable to open/run the query


"Joan Wild" <jwild@xxxxxxxxxxxxxxxx> wrote in message
news:#$nN15dpHHA.2156@xxxxxxxxxxxxxxxxxxxxxxx
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?














.