RWOP Not Working

[Matt]

I have a simple delete query built by a user with full permissions in the
database. The RWOP is set to "Owner". When a user with no access to the
design of the target table executes code that uses the query, they get an
error 3033, no privelage.

Help?

 

[TC]

First, double-check that the query is owned by who you think it is:

msgbox dbengine(0).querydefs![the-query-name].owner

or somesuch.


Second, I *think* that in order to select, insert or delete from a
table, you must have Read Design to that table. Add that on, & see if
it works. I can't quite remember, & I don't have Access here to check.

HTH,
TC

 

[TC]

msgbox dbengine(0).querydefs![the-query-name].owner

Probably: (0)(0)
not: (0)

Second, I *think* that in order to select, insert or delete from a
table, you must have Read Design to that table. Add that on ...

.... to the less-priviliged user (not the query owner).

HTH,
TC

 

[Joan Wild]

I have a simple delete query built by a user with full permissions in the
database. The RWOP is set to "Owner". When a user with no access to the
design of the target table executes code that uses the query, they get an
error 3033, no privelage.

Users do not need any permissions on the table, however you must grant them
delete permission on the RWOP query.