Re: tab control & user level security
From: chris (chrisderoover_at_hotmail.com)
Date: 03/29/04
- Next message: PC: "Refresh Recordset after NotInList update"
- Previous message: Steve Schapel: "Re: Huge database weighs heavily on small brain"
- In reply to: TC: "Re: tab control & user level security"
- Next in thread: Lynn Trapp: "Re: tab control & user level security"
- Reply: Lynn Trapp: "Re: tab control & user level security"
- Reply: TC: "Re: tab control & user level security"
- Messages sorted by: [ date ] [ thread ]
Date: 29 Mar 2004 01:09:41 -0800
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: PC: "Refresh Recordset after NotInList update"
- Previous message: Steve Schapel: "Re: Huge database weighs heavily on small brain"
- In reply to: TC: "Re: tab control & user level security"
- Next in thread: Lynn Trapp: "Re: tab control & user level security"
- Reply: Lynn Trapp: "Re: tab control & user level security"
- Reply: TC: "Re: tab control & user level security"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
