User access to view a report

  • Thread starter Thread starter Sheila
  • Start date Start date
S

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?
 
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.
 
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"
 
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
Sheila said:
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"
Click to expand...
 
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
Sheila said:
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"
Click to expand...
 
Back
Top