How to hide the mySys Tables

S

Sean Ferrin

When I open a new Access database I see preloaded tables. Is there a way to
hid e them? Here are some examples:

mySysObjects
mySysQueries

Thanks
 
B

BruceM

Open a database. Click Tools >> Options. Click the View tab, and clear the
System Objects check box.

This assumes Access 2003 or earlier. I don't know exactly how to find the
option in Access 2007.
 
D

Douglas J. Steele

What version of Access? For Access 2003 and earlier, choose Tools | Options
from the menu, and uncheck System Objects on the View tab. Unfortunately, I
don't have Access 2007 installed on this machine, and I can't remember where
to find the option in that version.
 
J

JulieS

Sean Ferrin said:
When I open a new Access database I see preloaded tables. Is there a
way to
hid e them? Here are some examples:

mySysObjects
mySysQueries

Thanks
Click to expand...

In Access 2007, right click on the navigation area, select navigation
options and uncheck "Show System Objects."

Julie
 
A

Albert D. Kallal

JulieS said:
In Access 2007, right click on the navigation area, select navigation
options and uncheck "Show System Objects."

Julie
Click to expand...

Glad you shared that tip, as it REALLY different to find that option in
a2007....
 
J

JulieS

Albert D. Kallal said:
Glad you shared that tip, as it REALLY different to find that option
in a2007....
Click to expand...
Happy to. It took me a few minutes to remember where it was.

Julie
 
Top