Change an encrypted view in an Access project

You can encrypt views to prevent a user from changing the view. However, once you encrypt a view, you can't change it's design. If you anticipate the need to revise an encrypted view, save the SQL in a text file in a secure location before you encrypt it.

To change an encrypted view:

1. Delete the old encrypted view.
2. Create a new view with the same name.
3. Cut and paste the SQL statement from the saved text file into the SQl pane of the new view.
4. Revise the new view as needed.
5. Save the revised SQL statement in a new text file in a secure location
6. Encrypt the new view. Additional information on encrypting views can be found in Microsoft SQL Server Help.