User access to view a report

[Sheila]

I gave the user permission to view a report but the user get the following
popup box when attempting to open record

Record(s) cannot be read; no read permission on "reportname"

What do I need to do to fix this?

 

[Joan Wild]

Are you certain it's 'no read permission on 'reportname''? Or is it the recordsource for the report. The user needs read permission on the query/table that the report is based on.

 

[Sheila]

Joan - No it does not refer to the record source. I do not want them to have
access to the table just the report. It states no read permssion on
"reportname"

 

[Joan Wild]

Double-check the users' permissions. They will need Open Permission on the report object. Don't forget the sub as well, if there is one.

They must have at minimum read permission on the recordsource or they won't be able to open it.

--
Joan Wild
Microsoft Access MVP

Joan - No it does not refer to the record source. I do not want them to have
access to the table just the report. It states no read permssion on
"reportname"

 

[Joan Wild]

Double-check the users' permissions. They will need Open Permission on the report object. Don't forget the subreport as well, if there is one.

They must have at minimum read permission on the recordsource or they won't be able to open the report.


--
Joan Wild
Microsoft Access MVP

Joan - No it does not refer to the record source. I do not want them to have
access to the table just the report. It states no read permssion on
"reportname"