Re: FE/BE Security

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Date: Fri, 11 Jun 2004 09:59:54 -0400

Did you secure both databases using the same workgroup file?

There is something amiss given your test FE performed correctly. 

-- 
Joan Wild
Microsoft Access MVP
"dickw" <dickw@att.net> wrote in message
news:jNednV8_pPfOflXdRVn2iQ@harbornet.com...
> There is definately something strang going on.  I tried securing a new
copy
> and got the same performance.  The first time I secured the db I used the
> wizard.  This time it secured it manually.  I made a new simple db and
> linked to the tables.  With this db, the permissions applied to the BE
> override any more liberal permissions applied to the test db.  I don't
know
> where to look for the problems in the FE.  The I would think it must be
> something in my coding but the same thing happens when I open the FE with
no
> forms opening or autoexec running, only the database window showing.  I
> can't see anything that should affect security.
>
> I certainly would appreciate any ideas.
>
> ***
>
>
> "Joan Wild" <jwild@nospamtyenet.com> wrote in message
> news:OEQVsIyTEHA.3988@TK2MSFTNGP10.phx.gbl...
> > "dickw" <dickw@att.net> wrote in message
> > news:47OdnTd5RsyjKFXdRVn2jg@harbornet.com...
> > > >
> > > I have double checked that the Users group has no permissions.  The
> > > Read-Only user is only a member of the Read-Only group and users.  If
I
> > open
> > > the BE, the Read-Only user has only read permission.  As soon as I
open
> > the
> > > FE, this same user has full data permissions, even when I open a
linked
> > > table directly.
> >
> > That is baffling.  I don't know what to suggest.  I was about to say
that
> in
> > the frontend they might be adding/modifying because they are using a
RWOP
> > query, but then you said they can add/modify in the linked table.
> >
> > Doesn't make sense to me; shouldn't be so.
> >
> > -- 
> > Joan Wild
> > Microsoft Access MVP
> >
> >
>
>
Quantcast