[AccessD] Split table's records according to user acoount

Non Linear nonlinearly at gmail.com
Mon Mar 19 09:48:09 CDT 2012


2007

2012/3/18 Charlotte Foust <charlotte.foust at gmail.com>

> What you say is only true if the query is not constructed to be updateable
> or you are binding to fields in more than one table.  What version of
> Access are you working with?
>
> Charlotte Foust
>
> On Sun, Mar 18, 2012 at 5:53 AM, Non-Linearly <nonlinearly at gmail.com>
> wrote:
>
> > "I don't get the not updateable part"
> > Well in Access a form can be bound to a table or query. If we have a
> table
> > or query without joins to other tables then the form is updateable which
> > means that every time you edit a record then the changes automatically
> > saved!
> > If don't (the form is bound to a query with joins to other tables) then
> you
> > have not this feature (you cannot edit any record in form).
> > So the solution is a form bound to a query without join that has a where
> > clause to filter the records based on user's security level.
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Benson,
> William
> > (GE Global Research, consultant)
> > Sent: Sunday, March 18, 2012 12:37 PM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Split table's records according to user acoount
> >
> > Why on earth....
> >
> > Until you wrote what you did in response to Charlotte, hers is exactly
> the
> > solution I imagined....
> >
> >
> > A user has a security level, and the record has a security level, and any
> > time a user has a security level above that required for the record, they
> > can see it.
> >
> > You need joins to the user privileges table.
> >
> > I don't get the not updatable part.
> >
> > I am not much good with that aspect, I believe it is handled through
> > relationships.
> >
> > Dunno - but quality databases do  it all the time. Absolutely, users
> never
> > see the table. Only a view prepared for them.
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Non-Linearly
> > Sent: Sunday, March 18, 2012 4:03 AM
> > To: 'Access Developers discussion and problem solving'
> > Subject: Re: [AccessD] Split table's records according to user acoount
> >
> > Thank you very much, so in the worst case I need so many levels of
> security
> > as there are users...
> > (although in this worst case that I do not have overlap then it will the
> > same to assign each record with a user account).
> >
> > Thanks
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
> Benson
> > Sent: Saturday, March 17, 2012 7:54 PM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Split table's records according to user acoount
> >
> > Dont assign users to records assign security levels to both user and
> > records.
> > On Mar 17, 2012 1:02 PM, "Non-Linearly" <nonlinearly at gmail.com> wrote:
> >
> > > I want the records in a table to distribute according to its users. I
> > > could create a field that holds for each entry, the user that has the
> > > rights to see it. But the problem is that a record may need to be
> > > viewed from more than one user!
> > >
> > > So I made a second table that more than one records each with the user
> > > account and the id from the first record. So with this way I can
> > > assign more than one user to one record.
> > >
> > > But then more problems emerge:
> > > 1. To take the records assigned to a specific user I have to run a
> > > query that join the above tables. The form that is bound to this query
> > > cannot be updateable!
> > >
> > > 2. The query can be achieved only with IN operator and is very very
> > > very slow.
> > >
> > >
> > >
> > > Thanks
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> >
> >
> > > Website: http://www.databaseadvisors.com
> >
> >
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> >
> >
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> >
> >
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> >
> >
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> >
> >
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list