Data Management

Hide Access database objects from unauthorized users

If you're working on a new Access form for your database that you don't want released to the public just yet, you can prevent others from accessing this form. Mary Ann Richardson explains to hide the icon of a form under development.

You're working on a new Access form for your database that you don't want released to the public just yet. One way you can prevent others from accessing this form is by keeping the form's icon from displaying in the database window. For example, to hide the icon of a form under development, follow these steps:

  1. Open the database window.
  2. Go to Tools | Options.
  3. Click the View tab.
  4. Clear the Hidden Objects check box under Show.
  5. Click OK.
  6. Click on Forms Under Object.
  7. Right-click the form.
  8. Select Properties.
  9. Click to select the Attributes: Hidden check box, click Apply, and then click OK.

When you're ready to work with the hidden objects, redisplay them in the database window by following these steps:

  1. Open the database window.
  2. Go to Tools | Options.
  3. Click the View tab.
  4. Click the Hidden Objects check box and then click OK. The hidden objects are now displayed as dimmed icons in the database window.
  5. Right-click the object you want to unhide and select Properties.
  6. Clear the Attributes: Hidden check box.

Caution: Because of the ease with which users can open and work with "hidden" objects, never consider this a viable method for securing your database.

Miss an Access tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks