Report using RWOP (owner permissions on secured table)

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


0
Beth
3/20/2007 11:43:51 PM
access.reports 4434 articles. 0 followers. Follow

0 Replies
745 Views

Similar Articles

[PageSpeed] 58

Reply:

Similar Artilces: