ACC2000: No Warning Message When You Set Encrypt View Option (224530)


The information in this article applies to:

  • Microsoft Access 2000
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 <viewname>

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

  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

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.
Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbbug KbClientServer kbpending KB224530
©2004 Microsoft Corporation. All rights reserved.