you do not have the necessary permissions...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ron - 29 Mar 2004 22:17 GMT

I have a mdb with user level security on it. I have
myself setup as one of the admins.

I added a user and gave him Admins security level via the
security wizard, however whenever he tries to perform an
append query, it gives him:
"You do not have the necessary permissions to use
the...object. Have your system administrator or the
person who created this object establish the appropriate
permissions for you."

??? If I've given him Admins, what the heck else do I
have to do?

Reply to this Message

Lynn Trapp - 29 Mar 2004 23:13 GMT

Is your user logging in via the same .mdw file that you used to secure the
database?

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> I have a mdb with user level security on it. I have
> myself setup as one of the admins.
[quoted text clipped - 9 lines]
> ??? If I've given him Admins, what the heck else do I
> have to do?

Reply to this Message

Ron - 29 Mar 2004 23:20 GMT

Yes. I can sit down at his PC and log on with my sign-on
and it works fine. But if he signs it, it bugs out.

I have tried deleting him and re-adding. I've tried
adding him under a different name. No luck. This has
really got me scratching my head. Prior to this, the
security wizard has been a real no-brainer that hasn't
had any problems.

>-----Original Message-----
>Is your user logging in via the same .mdw file that you used to secure the
[quoted text clipped - 15 lines]
>
>.

Reply to this Message

Lynn Trapp - 29 Mar 2004 23:27 GMT

Then make certain that he has full permissions to the folder that the
database is stored in.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> Yes. I can sit down at his PC and log on with my sign-on
> and it works fine. But if he signs it, it bugs out.
[quoted text clipped - 30 lines]
> >
> >.

Reply to this Message

Ron - 30 Mar 2004 17:19 GMT

Thought of that too. He has full permissions to the
Novell folder where the mdb is located. I even had him
copy-paste a file into the folder to be sure.

He can run regular 'select' queries, just not the table
altering ones. I've even tried giving him different
permissions such as project designer,etc. But they all
bug out on that append query.

Pretty strange.

>-----Original Message-----
>Then make certain that he has full permissions to the folder that the
[quoted text clipped - 36 lines]
>
>.

Reply to this Message

Lynn Trapp - 30 Mar 2004 18:47 GMT

Now you are starting to intrigue me. Have you tried creating an append
query under his user name and running it? That might tell you whether or not
there is some problem with the append query you are having an issue with.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> Thought of that too. He has full permissions to the
> Novell folder where the mdb is located. I even had him
[quoted text clipped - 58 lines]
> >
> >.

Reply to this Message

Ron - 31 Mar 2004 17:53 GMT

The month end processes which are causing all the grief
consists of:

1. Append query (writes last months data to main tbl)
2. Make Table query (temp table for current
data..overwrites previous month's temp table)
3. Del query (del expired data in main tbl)
4. Select-query-A, Select-query-B (processes comparison
b/w current and main tbl's)

I just tried creating a new user account and assigned
Admins/Users rights to it.

I signed on as new user and was able to see design view
on 1, 2, 3, but on 4 it said I didn't have permission to
design view Select-query-B. BUT it allowed me to run
Select-query-B.

So I started at the beginning and ran them in order. 1,
2, 3 ran but 4 said I didn't have permission. How is it
that I could run it a minute ago, but not now?!

Hmm..So the newly created user account got further along
than the guy who started all this grief, but still didn't
make it all the way through.

So I signed on as myself and went through all 4 without a
hitch. Man, this has got me scratching my head.

>-----Original Message-----
>Now you are starting to intrigue me. Have you tried creating an append
[quoted text clipped - 65 lines]
>
>.

Reply to this Message

Lynn Trapp - 31 Mar 2004 19:43 GMT

Your scenario is so odd that I'm starting to suspect that there may be some
deep seeded corruption in the database. Have you compacted the database
lately?

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> The month end processes which are causing all the grief
> consists of:
[quoted text clipped - 108 lines]
> >
> >.

Reply to this Message

Ron - 31 Mar 2004 20:02 GMT

Compact and Repair Database is the first thing I do when
something starts acting quirky.

I'm about at the point of removing security from the MDB
and saying the heck with it.

>-----Original Message-----
>Your scenario is so odd that I'm starting to suspect that there may be some
[quoted text clipped - 115 lines]
>
>.

Reply to this Message

Lynn Trapp - 31 Mar 2004 23:07 GMT

You may want to try using Jetcomp, as that sometimes removes more corruption
than the built in compact and repair does.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> Compact and Repair Database is the first thing I do when
> something starts acting quirky.
[quoted text clipped - 149 lines]
> >
> >.

Reply to this Message

MXSComputer - 29 Aug 2007 01:46 GMT

Under User and Group Permissions, assign all but admin permissions to <New
Tables/Queries>.

>You may want to try using Jetcomp, as that sometimes removes more corruption
>than the built in compact and repair does.
[quoted text clipped - 4 lines]
>> >
>> >.

Reply to this Message