Permissions and Database access

You can set access levels for users or user groups to be able to view data for your table in a read-only state, while an administrator such as yourself could then have read/write access to it. If I read your question correctly and you want them to only be able to see certain fields within a table, you will have to use some external query to pull specific fields and lock the records that way.

Make it possible for them to see a form that only shows the fields you want them to see. Limit their access to just this form.