Hide Access database objects from unauthorized users

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: