Show or hide database objects

Microsoft Office Access 2003

  1. Under Objects in the Database window, click the type of database object whose properties you want to change.
  2. Click Properties Button image on the toolbar.
  3. Select or clear the Hidden check box.

Note  In a Microsoft Access project, you cannot change the properties of a table, query, or database diagram because these objects reside in the Microsoft SQL Server database. However, you can change the properties of a form, report, macro, or module, because these objects reside in the Access project itself, not in the Microsoft SQL Server database. You can also change the properties of a data access page.

Show Show or hide objects defined as hidden by default

If you need to work with objects that are defined as hidden without changing their status as hidden, you can display them in the Database window.

  1. On the Tools menu, click Options.
  2. Click the View tab.
  3. Under Show, select or clear the Hidden objects check box. Microsoft Access displays hidden objects with dimmed icons to distinguish them from objects that aren't defined as hidden.

Show Show or hide system objects by default

Microsoft Access automatically creates system objects when you create a new database.

  1. On the Tools menu, click Options.
  2. Click the View tab.
  3. Under Show, select or clear the System objects check box.