Linking Back-end RWOP Queries

[M_S_Jones]

Hello,

I know there are posts on forums all over the internet on this topic, but it is just one aspect in particular that I would like some simple advice on. I have worked through user-level security suggestions online and made a test back-end database that has a user and a group, named "Developer." All of the privelleges are activated for Developer. Developer is the only user who can access the data of "Table1." I've created an RWOP query that retrieves the data from Table1, Developer is the owner of this query. I've also created a front end and tried to create a link to Table1; which is denied, as I had hoped it would be. My question is this: How should I structure my front-end so that users can retrieve data from this query, but cannot obtain the data using a different front-end?

Thank you very much for any advice you can offer,

Matt

 

[M_S_Jones]

I've Got it Working!

I have found what my problem was. I'm posting my solution on here in case anybody else gets stuck at the same point I did. I had been using the RWOP queries incorrectly. I had changed the permissions so that no one except the developer user could run them (to prevent the other uses creating a new database and writing links to them and thereby gaining access to the data). I've now used the queries as the record sources for a number of forms that contain the data for authorised users (I've basically used them to retrieve data from the tables in back end, which the users no longer have permission to view). To do this I had to change the permissions of the queries so that these users can view and update the data. However, I have named the RWOP queries in the back end with unpredictable names, so that users shouldn't be able to guess them and write links to them.