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

Non-Linearly nonlinearly at gmail.com
Sun Mar 18 03:02:34 CDT 2012


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



More information about the AccessD mailing list