Change an encrypted view in an Access project (ADP)
Microsoft Office Access 2003
Delete the old encrypted view.
Create a new view with the same name.
Cut and paste the SQL statement from the saved text file into the SQL pane of the new view.
Revise the new view as needed.
Save the revised SQL statement in a new text file in a controlled location.
Encrypt the new view. Additional information on encrypting views can be found in Microsoft SQL Server Help.