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?

Answer 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.