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

The simple approach is relational.  You have a table of users and a table
of groups/permissions.  You have a join table that links users to groups
and permissions  You have a table of records with a field that indicates
the group/permission required to see the record. If you're displaying the
records in a form, you filter the form's recordset based on the join table
of users and permissions.  You NEVER, under any circumstances, let your
users see the table.  In versions below 2007, you can use built in Access
security to handle it.

Charlotte Foust
On Sat, Mar 17, 2012 at 10:01 AM, 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
>
>
>