Password Protect Query

[austenr]

How can you password protect a query so no one can make changes? A non programmable answer would be best but if it cannot be done that way a programatic one will be fine. Thanks

[geekgirlau]

Generally you would protect it via security - have you looked into this option?

[austenr]

I have played around with it last night. I am a little confused because when I tried to set it it asked for a PW to open the DB. I only want a PW protect on the query itself. :dunno

[xCav8r]

There's no good way to do what you want to do. geekgirl has the right idea. If you need to start restricting access to certain things, then you need to start a workgroup and determine the access settings for each of your objects. Some alternatives are hiding the query (and the underlying tables) or creating a different front-end for your database where it's not present. HTH! :)