RWOP Not Working

9 Apr 2005 6:55 PM

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?

10 Apr 2005 3:56 AM

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

10 Apr 2005 4:03 AM

TC

TC wrote:

> 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

12 Apr 2005 10:20 PM

Joan Wild

"Matt" <M***@discussions.microsoft.com> wrote in message
news:E4A800F7-411E-4BA0-A944-1320C07BB4D4@microsoft.com...
>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.

--
Joan Wild
Microsoft Access MVP