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

jwcolby jwcolby at colbyconsulting.com
Sun Mar 18 07:23:05 CDT 2012


Assign security to groups and users and records to groups.

This kind of stuff is almost impossible in Access directly but can be done in SQL Server.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 3/18/2012 4:02 AM, Non-Linearly wrote:
> 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