Permissions problem - Can't use RWOP

T

TK

I have taken all permissions off my BE and am trying to set up all queries,
forms, reports, etc. in the FE to run with owners access option, but it
won't work. In some of my queries, I call a function which has to send one
of the fields from the participating table. Since there are no permissions
on that table, the user can't run the query.
Is there a way around this?
Thanks in advance.
TK
 
J

Joan Wild

TK said:
I have taken all permissions off my BE and am trying to set up all
queries, forms, reports, etc. in the FE to run with owners access
option, but it won't work. In some of my queries, I call a function
which has to send one of the fields from the participating table.
Since there are no permissions on that table, the user can't run the
query.
Is there a way around this?
\
Click to expand...

What function are you using? Can't you reference a RWOP query rather than
the table?
 

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

RWOP and passing variables to a function 3
rwop and combo lookup table 1
RWOP and Permissions Urgent help is required 1
Can't run RWOP queries in Access 2000 1
Form behavior after security implemented 4
RWOP /table permissions question 6
limiting table access and RWOP queries 16
Group Permissions and SQL 6

Top