×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Microsoft Access Project (ADP) - Report Recordsource Permission Error

Microsoft Access Project (ADP) - Report Recordsource Permission Error

Microsoft Access Project (ADP) - Report Recordsource Permission Error

(OP)
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 are basically identical (same fields, same recordsources, etc.)  Both have two levels of subforms/reports.  The form works perfectly, users can insert, update and delete records.  The report works fine (opened via VBA form button click event) for any user with db_datareader permission, but won't open for anyone without it.  Gives an error.

The error msg:
"The record source '<<My View>>' specified on this form or report does not exist"

I have qualified my views with the appropriate Schema, e.g., Recordsource: MySchema.MyView, Recordsource Qualifier: MySchema

I've seen several posts regarding this error when the record source is a sproc, but in my case it's a view, and the users have permissions on that particular schema.  Obviously this is a permissions issue, but I'm at a loss.  As a workaround, I tried to copy the recordsets from the form & subforms to the reports but the middle tier subreport is giving me an error.  Sigh...

Can anyone steer me in the right direction?  Thanks in advance!!
 

RE: Microsoft Access Project (ADP) - Report Recordsource Permission Error

Have you granted select permission to users/groups that you want to be able to run the report?

RE: Microsoft Access Project (ADP) - Report Recordsource Permission Error

(OP)
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 recordsource?  Any advice would be useful.

(I'm waiting for trace permissions on the SQL Server so I can troubleshoot that way.  Wondering if reports read some kind of system table?).

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close