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

Ok with one note: form's recordset must be based on one table (with a where
clause in the permission field of the record) else if the recordset is based
in a query with joins then the bound form will not be updateable...

Thanks

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Sunday, March 18, 2012 5:07 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com