RWOP and Permissions Urgent help is required

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Julius - 27 Feb 2007 22:38 GMT

Ok this is getting more difficult than it should be. I used the User-Level
Security Wizard and went step by step, then I went into my queries and open
them in designed mode and applied the owners permission to every querie that
exist. Yet I continue to get a You do not have the necessary permission to
use the xyz table object. Have your system admin or the person who created
this object establish the appropriate permissions for you. I have tried
everything but to no avail. I really need help I really need to setup this
security. Question if the queries are action queries will the RWOP apply. If
not then how to I administer seccurity. If I hve no choice but to hide the
tables, will my other admin and myself be able to see those tables. PLEASE
HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Reply to this Message

Joan Wild - 27 Feb 2007 23:21 GMT

When do you get this error. It may be happening if you have rowsources for
comboboxes or listboxes set to tables, rather than RWOP queries. Also check
to see if you have any lookups defined at the table level.

Also are you changing the SQL property of any queries in code?

RWOP works fine for action queries. Remember that you have to assign the
appropriate permissions to the RWOP *query*, after removing permissions on
the underlying tables.

Signature

Joan Wild
Microsoft Access MVP

> Ok this is getting more difficult than it should be. I used the
> User-Level
[quoted text clipped - 15 lines]
> PLEASE
> HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Reply to this Message