I am doing the following in order to give some users access to selected tables via MS-Access...
Create a Windows Security group in Windows called "ABC:"
Create a Windows authenticated SQL user called "ABC"
Assign individual users to the "ABC" group
Assign Select permissions on the 3 tables for user "ABC"
This works with one exception, I want to exclude the Schema and system table....
Anyone know how to accomplish this ?