you do not have the necessary permissions...

[Ron]

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?

 

[Lynn Trapp]

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

 

[Ron]

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.

 

[Lynn Trapp]

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

 

[Ron]

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.

 

[Lynn Trapp]

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.

 

[Ron]

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.

 

[Lynn Trapp]

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?

 

[Ron]

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.

 

[Lynn Trapp]

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