Re: Hidden tables in query wizzard

"KNN" <knnh18@xxxxxxxxx> wrote

I have some tables with hidden attribute set
to 1. In the query desgn view , I do not see
these tables as expected. But, If I choose the
query wizard to create a new query, then i
do see these hidden tables. How to hide
these tables in the query wizard.

Tools | Options | View | Uncheck "Hidden Objects"

Then, if you "button down" your application sufficiently well (so the user
cannot change that Option), the user will not be able to see it. But, as
the developer, you would be well advised to be able to see and use the
hidden objects -- that is, you should have some reason for their being
there.

I agree with the principle: "If this is an application developed for other
users, users should not have access to Design View." And, would ask the
question: "If it is a database just developed for your own use, why would
you want to permanently hide Tables from yourself?"

As I understand it, the purpose for the Hidden Attribute is that you can
prevent users from seeing the hidden objects in a database application that
you are distributing an application to others for their use, or to hide some
objects just for your convenience, in a database on which you are working,
until you wish to view them again, and it appears to me that it is working
as intended/designed.

Larry Linson
Microsoft Access MVP


.