How to make a table read-only in Access?

ms-access ms-access-2013
user3497327 picture user3497327 · May 19, 2014 · Viewed 19.4k times · Source

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

Gord Thompson picture Gord Thompson · May 19, 2014

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.

Related questions

Access 2013 - Cannot open a database created with a previous version of your application

I have an Access database created more than 10 yrs back. I have very important data in it & I think it can be opened in Access 2007 or earlier version. Currently I have Access 2013 in my desktop and opening the file …

Read More
Combobox null in if statement

I am trying to code an if statement where if a certain combobox is null, then it runs a certain part of code if it has data in it then it runs another. I wrote up this: Private Sub ProjectAddSetDateAutoBtn_…

Read More
How to determine if a table contains a value in SQL?

I feel like I'm missing something very obvious here, but it seems that the only way to go about doing this is to get the value, and then see if it returns a null (empty) value, which I would rather …

Read More