I have a question about security. I do not know if it is at all possible but I will ask you anyway. I have a database that is used by multiple users and everyone has access to everything within that DB. As you can imagine this causes some problems from time to time. I was wondering if there is a way to secure records, meaning allowing one group of users access to certain records while restricting access for others all based on a project name or project ID. To simplify it even more when user opens a form that displays all projects I would like the DB to determine if the user is a group user and then follow these rules: Users in group 1 can view only information for projects A, B, C and users in group 2 can only view information in projects X, Y, Z, while users in group 3 can view all information about all of the projects.
Any help would be greatly appreciated