Allow Report Print, NO Database rights??

L

LeapYr60

How do I configure a user's Access so that he can only run and print a particular Access report, but NOT have any capability to make changes to the database tables or that report itself?

Matt
 
J

Joan Wild

LeapYr60 said:
How do I configure a user's Access so that he can only run and print
a particular Access report, but NOT have any capability to make
changes to the database tables or that report itself?
Click to expand...

You can implement security. The only permissions the user would need is
ability to open/run the database object and the report, and read data
permission on the record source for the report (best to use a RWOP query for
this)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2002 change report header text 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Weekly Report 2
Page numbering with Merged Document and IF statements 1
Blank Page After Envelope-Label Wizard 5
Access Lock File .LACCDB / Now shows as a notepad file 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Images are pixelated when saving to PDF 0

Top