How to make a table read-only in Access?

Question

I have made up Tracker form in Access 2013 in which end user update their daily routine tasks. I want to keep the table as read-only so that no one can make any unauthorized changes in the existing data.

Is there any way to do that in Access?

Solution 1

One solution would be to

• move the reference table into a separate database file,
• make that file read-only (e.g., by using Windows permissions on the file), and
• use a Linked Table in the main database to access the reference table.

Solution 2

Use a query in place of the table, and change its Recordset Type property to Snapshot.
If you want to avoid users opening the table itself, move the table to another database and change the Source property of the table to the path of the other database. In SQL it gives something slike:

SELECT * FROM myTable IN 'f:\test\hidden.mdb'