Query table

[gane_mi2]

Hi,

I am working to custmize the data base as i want... I opened one query in the design view... In that I can see 6 tables and queries are linked... But when i check the object window i can find only 3 Tables and queries... Remaining 3 tabels I could not find in the object list... I there any idea to find out where those 3 tabels stored? Your answers will help me to achive my task...

Thanks in Advance
Warm Regards
Ganesh

 

[jzwp22]

Those tables you are referring to are system tables. There is a setting that you can toggle to show the system tables. For Access 2007/2010, go to File-->Options-->Current Database. If you scroll down this page you will see a button under the Navigation heading entitled Navigation Options. Click that button. In the lower section of the window that opens is an option to Show System Objects

 

[gane_mi2]

Hi,

Really many thanks for the answer... But still i could not see those tables... Is there any other way to see those tables...

Thanks in advance...

Warm Regards
Ganesh

 

[jzwp22]

In the same location is another check box to Show Hidden Objects. Check that box as well in case the tables are not system tables (perhaps tables hidden by another developer?) You will have to close the database and reopen it for the changes to take affect.

 

[gane_mi2]

Thanks for your help to giving lot of options... still problem continues... But i learned other ways from you....

Warm Regards
Ganesh

 

[Pat Hartman]

The objects you see in the query could be tables or other queries. Have you looked in the query list?

 

[gane_mi2]

Hi Pat,

yes.. I did.... But there is no table or query in that name...

Warm Regards
Ganesh

 

[MSAccessRookie]

There are four standard types of "Tables" in an Access Database. There are Normal, Hidden, and System Tables, as well as Queries that are being used as Data sources for other Queries. If you have opted to display Hidden and System Objects, and still do not see the name in either the list of Tables or Queries, then something else must be going on.

Do the Entries that you see in the Design View have any Fields defined? If you see Fields, then the Table/Query does exist. If not, then the Table/Query may have been lost or removed, and the Query that you are viewing has not been updated. It would also mean that the Query that you are viewing is probably no longer in use.

 

[Pat Hartman]

If the tables/queries are suffixed with a number _1, _2, etc. that means the table is a copy of another and is used to make the diagram easier to read. The table isn't really duplicated, only it's picture is duplicated for the sake of the diagram.

 

[gane_mi2]

Hi Pat,

Awesome... U r right... The table names are duplicated... Now Here started my next question? Why do we need muliple table from same table in the releation ship window?

Warm Regards
Ganesh

 

[MSAccessRookie]

Hi Pat,

Awesome... U r right... The table names are duplicated... Now Here started my next question? Why do we need muliple table from same table in the releation ship window?

Warm Regards
Ganesh

This technique is commonly used when there is more than one Foreign Key to a Single Table in the Table that is being used. For instance, A Table could contain Signature Fields for the following four people:

• EnteredBy
• ReviewedBy
• ApprovedBy
• ArchivedBy

If The Name values are all Foreigh Keys to a Table called tblContacts, then the only way to show more than one name at a time is to have more than one copy of tblContacts in the Design, and have each copy Joined to a different Signature Field.

Is this what is going on with your Design View?

 

[gane_mi2]

Yes... I got it... Thanks...