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?

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 wrote:

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


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

HTH,
TC

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

Report of database object permissions
Security file not holding changes
Some users have to rejoin workgroup daily, why?
macro security error message
New to security have questions before plunging
how to secure a new db with an existing .mdw
Assign a workgroup to a workspace object - Thanks to Paul Overway
Opening MDB with and a workgroup file.
Reuse Secured.MDW file?
Workgroups & Distribution of my Application