Access SQL ADP - block fields based on authentication

I am looking to block Subforms and fields based on the level of authentication given to them in my MS SQL 2005 Server. If I do not give them Select access to the entire table it will not allow any of the rest of that form's data to be presented.
Bill WarrenIT ManagerAsked:
Who is Participating?
Anthony PerkinsConnect With a Mentor Commented:
Have you tried using VIEWs instead?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.