I have an Access 2003 front end linked to SQL Server 2005 tables.
Two groups of people are allowed access to the database, one group allowed to see certain tables/forms and the other group different tables/forms.
I am using Windows Authentication because these people have Windows groups already and have set up SQL Server Logins for them following the method in this question (http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_22971000.html?sfQueryTermInfo=1+permiss+secur
ie Use windows authentication
Use windows groups
Assign windows accounts to windows groups
Use group logins on SQL Server that correspond to the windows groups
Grant permissions to group logins
So my two Logins have select, update, delete, insert permissions on one of two different schemas and are denied these rights on the opposite one.
PROBLEM - it has made no difference!! as when they open the Access database they can still see all the linked tables and open them up etc. Does anyone know what I have done wrong - is there some VBA code I could use to see how the person is logging in and what permissions they have