Help and Support
 

powered byLive Search

ACC2: How to Hide Objects in the Database Window

Retired KB ArticleThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Article ID:114683
Last Review:November 6, 2000
Revision:1.0
This article was previously published under Q114683

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.

Back to the top

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.

Back to the top

REFERENCES

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

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

Back to the top


APPLIES TO
Microsoft Access 2.0 Standard Edition

Back to the top

Keywords: 
kbhowto kbusage KB114683

Back to the top

Article Translations

 

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.