Securing and Administering Access - Remove Database Objects from View

(Page 7 of 11 )

Hiding database objects does not really tighten security; it just keeps certain objects from appearing in the Database window.

Hide Database Objects


To hide an object:

1. Select the object in the Database window, and click Properties on the Database toolbar.
   
   
2. Check Hidden at the bottom of the General tab in the Properties dialog box, as shown in Figure 9-10.
   
   
3. Click OK.

NOTE  You can save the encoded version with the same name as the original, but you will be asked to confirm this. If the encode process fails, the original database is not deleted.

View Hidden Database Objects

Normally, the hidden object is no longer listed in the Database window; however, you can choose to see the names of the hidden objects.

1. Choose Tools | Options and click the View tab.
   
   
2. In the Show area, select Hidden Objects.
   
   
3. Click OK.

Although the hidden objects appear dimmed in the Database window, they can still be opened. To remove the Hidden property, open the Properties dialog box (see the previous section, “Hide Database Objects”) and deselect the Hidden option.

Figure 9-10: Use the object’s Properties dialog box to hide the object.

This chapter is from Microsoft Office Access 2003 QuickSteps, by Cronan, Anderson, and Anderson (McGraw-Hill/Osborne, 2004, ISBN: 0072232293). Check it out at your favorite bookstore today. Buy this book now.

Next: Back Up and Restore a Database >>
 

More Microsoft Access Articles
More By McGraw-Hill/Osborne

Comments On: Securing and Administering Access

· some time ago it was said that the workgroup file is needed to break into a secured...    · I\'m not sure about Access2003... but every other version of access that uses the...   >>> Post your comment now!