CODEWITHSUNDEEP
ms-accessms-access-2013
user3497327
user3497327

Reputation: 71

How to make a table read-only in Access?

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?

Upvotes: 6

Views: 25898

Answers (3)

iDevlop
iDevlop

Reputation: 25252

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'

Upvotes: 2

Gord Thompson
Gord Thompson

Reputation: 123399

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.

Upvotes: 3

E Mett
E Mett

Reputation: 2302

AFAIK you cannot make a table read only, but you can do a number of things to lock down the database so that the user only has access to forms that are read only.

In Options deselect:

  • Use Access Special Keys
  • Display Navigation Pane
  • Allow Full menus
  • Allow Default Shortcut Menus

In the form, set the following properties to No:

  • Allow Additions
  • Allow Deletions
  • Allow edits

Upvotes: 0

Related Questions