473,287 Members | 1,866 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Hidden tables in query wizzard

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
3 2845
"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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: mark.reichman | last post by:
First off.. Thanks to Grant Wagner for help in a previous thread related to this one. I am at a total loss... I have multiple fields in a form with the same name. Lets call the fields with the...
10
by: Mark McLellan | last post by:
Dear all Following the oft-repeated advice here and ciwas I have made my site nearly 4.01 strict (working on it). There are some items on which I would appreciate your advice: 1. Hidden...
2
by: Michael Donahoe | last post by:
I have a database that I inherited that has query in it that has hidden fields when it is in design view. Datasheet view shows the fields and when I switch back to design view it appears as though...
5
by: dixie | last post by:
If I sent a user an empty database container - dB with no tables and I needed them to import their tables into it and one of their tables was a hidden table with the prefix Usys, is there any way...
1
by: Gunnar | last post by:
I am finding some unusual behavior with techniques I am using to show/hide/update data without having to refresh the page. I'm quite sure it's developer ignorance on my part and would be grateful...
1
by: Graham Charles | last post by:
I'm trying to create a standard "hidden" table. However, using this code, my tables are not displayed in the database window *even* when I choose to show Hidden and System objects from the Options...
1
by: Farshid | last post by:
Hi Is there any way to use Visual Studio Query Builder in Windows Forms applications. I think query builder dialog is in Micosoft.VSDesigner assembly but i dont know how to use it. Thank You...
1
by: pemigh | last post by:
I'm almost done with an application, and trying to lock it down tightly. But I still want users to be able to point to a new location for the data file. The code below fires off to detect and...
6
by: dba | last post by:
using the following code with a problem.... echo "<input type='hidden' name='member_id' value=\"{$row}\">{$row}"; echo "<input type='radio' name='member_name' value=\"{$row}\">{$row}<br />"; ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.