ACC2: How to Hide Objects in the Database Window (114683)



The information in this article applies to:

  • Microsoft Access 2.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.

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

Modification Type:MajorLast Reviewed:11/6/2000
Keywords:kbhowto kbusage KB114683