Making a table read only

  • Thread starter Thread starter Andrew
  • Start date Start date
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
 
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.
 
Back
Top