Re: you do not have the necessary permissions...

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Lynn Trapp (ltrappNoSpam_at_ltcomputerdesigns.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 11:47:02 -0600

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. 

-- 
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
"Ron" <anonymous@discussions.microsoft.com> wrote in message
news:159f901c41672$ca898730$a301280a@phx.gbl...
> 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
> >database is stored in.
> >
> >-- 
> >Lynn Trapp
> >MS Access MVP
> >www.ltcomputerdesigns.com
> >Access Security: www.ltcomputerdesigns.com/Security.htm
> >
> >
> >"Ron" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:1548501c415db$fe76dbc0$a501280a@phx.gbl...
> >> 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
> >> >database?
> >> >
> >> >-- 
> >> >Lynn Trapp
> >> >MS Access MVP
> >> >www.ltcomputerdesigns.com
> >> >Access Security:
> www.ltcomputerdesigns.com/Security.htm
> >> >
> >> >
> >> >"Ron" <anonymous@discussions.microsoft.com> wrote in
> >> message
> >> >news:152be01c415d3$483d5bc0$a301280a@phx.gbl...
> >> >> 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?
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

Relevant Pages

  • Re: Running select and append queries to find data
    ... I'm not sure how you expect users to select/filter records and why they ... would append and keep duplicates. ... > the select query that hopefully will run earlier in the macro. ... >> MS Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Figuring out what field is causing key violation on append
    ... Nz converts nulls to whatever you put as the second argument. ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ... First try the query with just one field in the append query. ...
    (microsoft.public.access.queries)
  • Re: adding information/keeping history of user name and time stamp
    ... Try changing that query to something like this: ... This assumes that you have a control on your form that has FL.ID as it's ... >i have just created a simple append query.... ... >> MS Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: limited number of db in a project?
    ... MS Access MVP ... It seems like if I run a query with a large data result the error occures ... the query I can't see that there is anything specvial about the append ... "Duane Hookom" wrote: ...
    (microsoft.public.access.queries)
  • lame server messages in named.log
    ... Mar 30 05:42:30.526 security: info: client 202.52.250.176#1052: ... query (cache) denied ...
    (RedHat)