ACC2000: No Warning Message When You Set Encrypt View Option

View products that this article applies to.

This article was previously published under Q224530

Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access project (.adp).

↑ Back to the top

Symptoms

When you open a view in Design view, you receive the following error message:

Query Designer encountered a Query error:
Cannot open encrypted view <viewname>

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

More information

If you select the Encrypt View option in the properties page of a view and save the change, once you close the view, you are no longer able to open the view in Design view or use ALTER VIEW against that view.

Steps to Reproduce Behavior

1.	Open the sample Access project NorthwindCS.adp.
2.	In the Database window, click Views under Objects.
3.	Select Alphabetical List of Products and on the Edit menu, and click Copy.
4.	On the Edit menu, click Paste.
5.	For the view name, type Test, and click OK.
6.	Open the Test view in Design View.
7.	On the View menu, click Properties.
8.	In the properties page, select Encrypt View.
9.	Close the Test view, and click Yes when you are prompted to save changes.
10.	Try to reopen the Test view in Design view. Note that you receive the following error: Query Designer encountered a Query error: Cannot open encrypted view Test

↑ Back to the top

References

For more information about views, click Microsoft Access Help on the Help menu, type Creating Views in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

↑ Back to the top