Making a table read only

A

Andrew

Hi,

I want to have one of my tables protected so that it's contents cannot
be changed. Other tables are to be open as normal.

Can anyone point me in the right direction?

Cheers
 
A

Allen Browne

You could use Access security (system.mdw), but this idea might be enough:

1. Open the table in design view.

2. Open the Properties box (View) menu, and set these:
Validation Rule False
Validation Text No changes permitted.

The validation rule can never be satisfied, so no changes will be saved.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
How to have two tables on same line? 1
Sub projects added as read only in Master file which are saved on sharepoint 1
Protecting Word 2019 document 0
Text in note pane of "normal" display suddenly much larger 1
Embed the same Excel multiple times 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Lost my Table of Contents , Appendices and Page numbers ? 2

Top