Re: tab control & user level security
From: TC (no_at_email.here)
Date: 03/30/04
- Next message: cconga_at_charter.net: "Cannot download security downloads"
- Previous message: TC: "Re: tab control & user level security"
- In reply to: Lynn Trapp: "Re: tab control & user level security"
- Next in thread: TC: "Re: tab control & user level security"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 30 Mar 2004 11:31:10 +0930
I think he's asking how to do that in a general purpose way that takes
advantage of his existing security settings. See my other reply.
Cheers,
TC
"Lynn Trapp" <ltrappNoSpam@ltcomputerdesigns.com> wrote in message
news:OFaRGAcFEHA.2160@TK2MSFTNGP12.phx.gbl...
> Chris,
> I'm puzzled as to why you don't simply hide a tab page from users that do
> not have permissions to the content of a given page?
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
>
>
> "chris" <chrisderoover@hotmail.com> wrote in message
> news:90bdd240.0403290109.6801bf35@posting.google.com...
> > Sorry if I wasn't clear. I'd like to restrict the access at tab page
> > level. (once a user has access to a tab page, he may see/access
> > everything on that page).
> >
> > About the permissions: the thing is we spent a lot of time and efforts
> > setting up security groups and the proper permissions for each object
> > in the db. It seems a bit funny to me that this system does no longer
> > function when those objects (e.g. forms) are used on a tab page. I
> > would have liked Access to display a security message when a users
> > tries to activate a tab with an object he has no permissions for. But
> > apparently as soon as there is 1 tab page with such an object, Access
> > refuses to open the main form (the one with the tab control). So I am
> > forced to foresee in the code of the open event which tab pages to
> > hide/display based upon the users membership of security groups. But
> > than it's me doing the security management I thought Access would
> > do...
> >
> > chris
> >
> > "TC" <no@email.here> wrote in message
> news:<40677dc5_3@news.chariot.net.au>...
> > > You forsee a solution where a tab page has several subforms, and the
> current
> > > user has access to >some< of those subforms but not all of them
(because
> of
> > > user-level security restrictions)?
> > >
> > > I have never tried that & do not know the answer. But it should only
> take
> > > you a few minutes to set up a small test & try it for real.
> > >
> > > However, even if you >can< do that, I would recommend against it, from
a
> > > user interface viewpoint. IMO, if a user can access a certain page in
a
> tab
> > > control, he should be able to access the full content of that page -
> > > including any/all subforms on that page. Could you not design your
pages
> to
> > > meet that requirement? Would that simplify the redesign?
> > >
> > > As for how to "keep the permissions that have been set up for the
> subforms",
> > > I'm not sure what you're getting at there. Please give a bit more
> detail.
> > >
> > > HTH,
> > > TC
> > >
> > >
> > > "chris" <chrisderoover@hotmail.com> wrote in message
> > > news:90bdd240.0403280840.24000386@posting.google.com...
> > > > I have an application (Access XP, A2K format, split db) that has a
lot
> > > > of forms. It also has user level security and about 10 security
> > > > groups. Now the customer would like to reduce the number of forms
and
> > > > suggests the use of tab controls with several pages.
> > > > I know it's possible to look for group membership in the open event
of
> > > > a form and consequently hide/display certain pages but is there no
way
> > > > to keep the permissions that have been set up for the subforms? It
> > > > seems a lot easier to manage than have to recode when new groups or
> > > > pages are created.
> > > > At first sight, a user must have access to all subforms on the pages
> > > > of a tab control, otherwise he gets a security error. Am I right?
> > > > Someone have a clue? Many thanks in advance
> > > > Chris
>
>
- Next message: cconga_at_charter.net: "Cannot download security downloads"
- Previous message: TC: "Re: tab control & user level security"
- In reply to: Lynn Trapp: "Re: tab control & user level security"
- Next in thread: TC: "Re: tab control & user level security"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
