Re: backend table permission

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 13:40:46 -0400

Please specify, administer permission on what object - the database, the
tables, the links???

Administer permissions are not required to refresh - see the security FAQ.
It even outlines how to link with no permissions 

-- 
Joan Wild
Microsoft Access MVP
"Richardson" <INVALID.ashesr@mindspring.com> wrote in message
news:tzMxc.8215$uX2.5449@newsread2.news.pas.earthlink.net...
> The code that refreshes the links seems to require it.  I have tried
running
> the code without adminster permission and it fails.  It works only when
> administer permission is granted on the front end.  I am still able to
> restrict their access on the backend. I am going strictly on the
experience
> I have had with it, so there may be another workaround.
>
> Lori
>
>
> Joan Wild <jwild@nospamtyenet.com> wrote in message
> news:eSFvP#mTEHA.3404@TK2MSFTNGP10.phx.gbl...
> > That's not been my experience.  You can give users full permissions on
the
> > links in the frontend - they'll still be restricted to the permissions
> they
> > have on the backend tables.
> >
> > Where do they need administer permission?
> >
> > --
> > Joan Wild
> > Microsoft Access MVP
> >
> > "Richardson" <INVALID.ashesr@mindspring.com> wrote in message
> > news:NDLxc.8182$uX2.2226@newsread2.news.pas.earthlink.net...
> > > Since I have received such great advice from this group in the past,
> here
> > > goes another question.
> > > In my database (Access 2002) the first form after the splash is a form
> for
> > > the user to choose between 4 different backend locations.  The
database
> > then
> > > refreshes the links to those tables.
> > > The problem is that all users and groups need to be able to do this
> > refresh,
> > > but it seems they are unable to use the RefreshLink command unless
they
> > have
> > > adminster privleges on the tables.  I really don't want to give them
> that
> > > kind of permission for the tables.
> > > Does anyone have a suggestion?
> > >
> > > Lori
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: AllowBypassKey
    ... "A member of the Admins group of the ... workgroup file that was used to create the database". ... Administer permission is a specific permission, like Read Design permission, ...
    (microsoft.public.access.security)
  • Re: Pivot table borders
    ... It's easier to beg forgiveness than ask permission :-) ... I have used both tabular and outline format. ... > whenever I refresh the table a default set of borders automatically ...
    (microsoft.public.excel.setup)
  • Re: AllowBypassKey
    ... > Administer permission is a specific permission, ... > group of the workgroup file that was used to create the database. ... if I gave them Admins priviledges that would make them an Admin. ...
    (microsoft.public.access.security)
  • RE: security ID structure is invalid
    ... Not sure if this will help you, but I've heard that it helps to reboot the ... machine in question to refresh the permissions tables (or something like ... > i am facing with some permission issue. ... > trying to add the group on a folder residing on the NAS storage. ...
    (microsoft.public.windows.file_system)
  • Re: code access security
    ... Error 1 CREATE ASSEMBLY for assembly 'GmsSqlClr' failed because assembly ... owner has EXTERNAL ACCESS ASSEMBLY permission and the database has the ... make sure the database owner is mapped to the correct login on ...
    (microsoft.public.dotnet.languages.csharp)