ACC2: How to Hide Objects in the Database Window

 Last reviewed: May 14, 1997
Article ID: Q114683
The information in this article applies to:
  • Microsoft Access version 2.0

SUMMARY

When developing an application, you may want to create an object that is hidden in the Database window. Hiding objects helps reduce the number of objects available to users of your application, while still allowing them to return to the Database window.

This article describes how to create an object that is hidden in the Database window.

MORE INFORMATION

You can hide an object by causing Microsoft Access to treat the object as a system object. Note that the Show System Objects option must be set to No in the Options dialog box in order for this method to work.

To hide an object, preface the object name with "USYS" (without quotation marks). For example, to hide the Employees table in the sample database NWIND.MDB, change its name to USYSEmployees. Tables, queries, forms, macros, reports, and modules can all be hidden in this manner.

REFERENCES

Microsoft Access "User's Guide," version 2.0, Chapter 3

Microsoft Access "Building Applications," version 2.0, page 359

Additional query words: usys temporary invisible
Keywords : GnlApp kbusage
Version : 2.0
Platform : WINDOWS
Hardware : X86
Issue type : kbhowto

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.