Report using RWOP (owner permissions on secured table)

B

Beth

Hello,
I have a database that links to some tables where the permissions have been
removed for everyone except the owner. I am trying to make a report access
the data using owner's permissions.
In the recordsource I have the following:
SELECT Classes.Class FROM Classes WITH OWNERACCESS OPTION;

This isn't working. What am I missing?
I have about 35 reports that I would like to convert to this format so that
my tables are more secure.

Thanks,
Beth
 

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

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Running a report using Windows Scheduled Tasks 0
How to Secure a Category Projects' for their Project Owners Only 1
Access Permissions not set 6
How to change a table owner 1
Group Permissions and SQL 6
Setting recordsource to secured table 0
RWOP and Permissions Urgent help is required 1

Top