I am trying to create a calendar in Sharepoint which displays all calendar items from few sites in one collection and managed to display them using DataView Web Part. The problem is that when people don't have access permission to all of the source sites they get the web part displayed with the following text "Access denied. You do not have permission to perform this action or access this resource". What I would like them to see instead, is only the calendar items to the sites which they have access to. Am I using the right web part - i've tried content query too, but no success.
Any help will be appreciated. Thanks