Microsoft KB Archive/224530

= ACC2000: No Warning Message When You Set Encrypt View Option =

Article ID: 224530

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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).



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



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



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
 Open the sample Access project NorthwindCS.adp. In the Database window, click Views under Objects. Select Alphabetical List of Products and on the Edit menu, and click Copy. On the Edit menu, click Paste. For the view name, type Test, and click OK. Open the Test view in Design View.</li> On the View menu, click Properties.</li> In the properties page, select Encrypt View.</li> Close the Test view, and click Yes when you are prompted to save changes.</li> 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

</li></ol>

<div class="references_section">