ACC2000: No Warning Message When You Set Encrypt View Option

• Microsoft Access 2000

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:




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