Disable editing from a microsoft query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rohitdiwan
    New Member
    • Dec 2014
    • 1

    #1

    Disable editing from a microsoft query

    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?
  • Luuk
    Recognized Expert Top Contributor
    • Mar 2012
    • 1043

    #2
    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

    Working...