Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2003

Angela has attended:
Access Advanced course

Access 2007

How do I hide the tables etc when a database is opened

Edited on Mon 28 Jul 2008, 13:56

RE: Access 2007

Hi Angela

Hide objects and groups

Hiding an object or group in Access is usually a better and easier option when you want to restrict access to it. Hiding objects does not change the database.

To hide an object in the Navigation Pane, right-click the object, and then click Hide in this Group.

To hide an entire group in the Navigation Pane,, right-click the group header (eg Tables), and then click Hide .

Unhide objects and groups

You can display hidden objects or groups without providing access to them. To do this:

Right-click the menu bar at the top of the Navigation Pane , and then click Navigation Options .

In the Navigation Options dialog box, select the Show Hidden Objects check box, and then click OK .

The hiddden objects and groups appear dimmed in the Navigation Pane as they are not enabled.

To enable an object, right-click the object, and then click Unhide in this Group.

To unhide a group, right-click the group, and then click Unhide.

Hope this helps

Carlos

RE: Access 2007

Hi - thanks for this. Do you know if there is a way to hide the Navigation Pane itself, rather than just objects or groups in it?

Thanks

Angela

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.