only allow users to access data through queries NEVER DIRECT TABLES
Posted on 2013-12-22
hey guys, i have an inkling that a best practice is to always use a query to allow users to access data and NEVER a table.
here's an example. i have a staff table which i would like the users to edit. without over-engineering things, i am thinking of just exposing the table to them to edit (treating it like a spreadsheet). however i have somehow think that i should always create a query first and only let the users edit the table's data through the query --> even though it's an exact 1 to 1 field mapping.
Question --> 1) how can i expose a table to the users and not allow them to edit the design of it?
2) what are the reasons why i should ALWAYS use queries to show users data or let them edit it, even though it's a 1 1 field mapping?
thanks in advance guys! = )