By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,889 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,889 IT Pros & Developers. It's quick & easy.

Hidden tables in query wizzard

P: n/a
KNN
Hi

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.

Thanks

Sep 4 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"KNN" <kn****@gmail.comwrote
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
Sep 4 '07 #2

P: n/a
KNN
On Sep 4, 7:26 pm, "Larry Linson" <boun...@localhost.notwrote:
"KNN" <knn...@gmail.comwrote
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
Thanks for the reply.

Probably I should have given you more information.

I have few standard tables, few linked tables and few queries. For
all these objects hidden attribute is set to 1. In the table pane or
the query pane I do not see the these objects as expected. Now, if I
select the design view for creating the queries, application will not
display these hidden objects as expeted, to be part of a new query.
The issue is, if I select simple query wizzard to create a new query,
then the wizzard displays hidden linked tables in the list of tables
and I can create new queries using these hidden linked tables which
defetes the purpose of hiding linked tables.
Sep 5 '07 #3

P: n/a
IMNSHO, if you choose to give the users the ability to create queries, that
implies that you are giving them the ability to view the Database Window and
you are giving them access to Design View, and that is likely a much greater
problem than being able to view hidden tables in the Query Wizard. And, I do
not understand why you'd want to hide the Tables, Queries, or whatevers from
yourself.

Larry Linson
Microsoft Access MVP
"KNN" <kn****@gmail.comwrote in message
news:11*********************@y42g2000hsy.googlegro ups.com...
On Sep 4, 7:26 pm, "Larry Linson" <boun...@localhost.notwrote:
>"KNN" <knn...@gmail.comwrote
> 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

Thanks for the reply.

Probably I should have given you more information.

I have few standard tables, few linked tables and few queries. For
all these objects hidden attribute is set to 1. In the table pane or
the query pane I do not see the these objects as expected. Now, if I
select the design view for creating the queries, application will not
display these hidden objects as expeted, to be part of a new query.
The issue is, if I select simple query wizzard to create a new query,
then the wizzard displays hidden linked tables in the list of tables
and I can create new queries using these hidden linked tables which
defetes the purpose of hiding linked tables.


Sep 6 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.