Thanks for responding. I got pulled off on something else and haven't come back to this yet.
Yes... users can access (& even edit) data from the very same views via a form. That's why I'm stumped. Don't know why the report would behave differently than the form when they use the exact same...
Hi folks,
My environment:
Front end: Access 2007 ADP, Back end: SQL Server 2005, Security: Windows login, I created Schemas and roles to control access, and I only expose data through views (with metadata option, to encapsulate the tables).
My problem:
I have a report based off a form. They...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.