How to make a table read-only in Access?
ms-access, ms-access-2013
Solution
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.
Problem
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?