Hello,
Is it possible to grant permissions to view a report only, but not the queries/tables from which it is derived? Currently it appears that Access will not allow a user to view a report unless the user has permissions for all of the related queries and tables it is associated with.
There is information in a single table that I need employees to see, but that same table also has information that I do not want them to see.
Thanks in advance,
Dan