Password protect a query

[mert]

I have a database that I want to protect a portion of with a password. The
database has one table and one query.

I need to be able to edit the main table and the query, but I want people to
ONLY be able to VIEW the query I have set up. They should not be able to edit
the query in any way, and they should not be able to open the table at all.

Is this possible?

 

[Arvin Meyer [MVP]]

I have a database that I want to protect a portion of with a password. The
database has one table and one query.

I need to be able to edit the main table and the query, but I want people
to
ONLY be able to VIEW the query I have set up. They should not be able to
edit
the query in any way, and they should not be able to open the table at
all.

Is this possible?

Not really. I suggest that you allow them to see data through a report in an
MDE which is connected to another DB with hidden objects. The chances of
anyone but an expert finding the source is small. If you put the data MDB on
a server, you can also use User-Level Security to deny all direct
permissions on the data. It's not perfect, and can be breached by an expert,
but it should keep about wandering non-dedicated malcontents.