Keep Track of Excluded Users for each Record
There's no easy way -- you just have to keep track of who is not allowed and
not show it to them. It's not clear how you've set up your database, so I
can't comment on the relative ease. If you only allow excluding four out of
200 users, then it seems quite limited. I might set up a "junction table"
between the "current record" table and the user table, so the user could
specify as many as desired. That would make it less limited, but not
necessarily any easier.
Quote:
> I am using a local Access database and have a tough question, my
application
> allows many users to add data to the local database. I want these users to
> have the option to exclude other users from seeing their current record.
> Currently I have four text fields that I use to store 200+ User ID's (5
CHAR
> long) (these are the excluded ones). I then have to use the software to
> extract whether or not a user is allowed to view that record. Can someone
> please give me a better way.
