Error msg, "you do not have the necessary permissions..."

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I am having trouble giving a user access to a database.

Originally it was just password protected, but I later
took that off and ran the security wizard an set it up
with user-level security.

I'm able to sign in to use it, but another user isn't
able to, he gets:
"You do not have the necessary permissions to use the
[query] object. Have your system administrator or the
person who created this object establish the appropriate
permissions for you."

This is just a select query, nothing fancy.

I started him off as a 'full data user' and when he
wasn't able to run the qry, I upgraded him
to "adminstrator". When this still didn't work, I tried
deleting him and adding him as a different user with
admin rights.

He still gets the error message. Any suggestions?
 
Ron said:
I am having trouble giving a user access to a database.

Originally it was just password protected, but I later
took that off and ran the security wizard an set it up
with user-level security.

I'm able to sign in to use it, but another user isn't
able to, he gets:
"You do not have the necessary permissions to use the
[query] object. Have your system administrator or the
person who created this object establish the appropriate
permissions for you."

This is just a select query, nothing fancy.

I started him off as a 'full data user' and when he
wasn't able to run the qry, I upgraded him
to "adminstrator". When this still didn't work, I tried
deleting him and adding him as a different user with
admin rights.

He still gets the error message. Any suggestions?
Click to expand...

Hi Ron,

Is this a split db?

I am not an expert in this area but
since you have not received a reply...

A kind-of-mantra from Access-L list
(as I remember it):

-groups are in the mdw
-all users must also be a member of Users group
but Users group should get no permissions
-*permissions* are in the FE and BE

If it is split, one typical misstep is to give
permission in *your* FE, and not give permission
in *other* FE(s).

I apologise for an answer that I have little experience with...
but had to reply just in case this was the situation.

Good luck,

Gary Walter
 
Back
Top