ACC2000: No Warning Message When You Set Encrypt View Option

ID: Q224530


The information in this article applies to:

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 <viewname>


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products 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

  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:


  11. Query Designer encountered a Query error:
    Cannot open encrypted view Test


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.

Additional query words: pra


Keywords          : kbdta AccessCS 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: May 13, 1999