I want to create a microsoft query which would pull data from an access database. I need my users to be able to filter the data however they wish, which I know is possible using a query. However, I don't want them to be able to make edits from a query. Is there a way I can disable a query from making edits to my table?
Disable editing from a microsoft query
Collapse
X
-
Tags: None
-
It all depends on the access rights the user has with that database.
If they just have READ rights, they always have the option to change the query, giving other results, but not changing/edition te table contents.
If they also have WRITE rights, they are able to change it to 'DELETE FROM table'
Comment