can't find tables used in query

  • Thread starter Thread starter Buboy
  • Start date Start date
B

Buboy

hi! my boss wants me to convert an Access database to a SQL Server. the
problem is that i can't find the tables being used in the query. how is
this possible? how can i view the tables which are being used by the query?
when i export the query to another database (access or sql server) i get an
error because the tables can not be found. is it possible to hide the
tables? tnx!
 
Buboy said:
hi! my boss wants me to convert an Access database to a SQL Server. the
problem is that i can't find the tables being used in the query. how is
this possible? how can i view the tables which are being used by the query?
when i export the query to another database (access or sql server) i get an
error because the tables can not be found. is it possible to hide the
tables? tnx!
Click to expand...

Buboy,

In Access, open the QueryDef.

1) In Design View, the tables are displayed at the top of the window, above
the Query By Expression Grid.

2) In SQL View, just read the Table names from the FROM clause.


Sincerely,

Chris O.
 
Yes it is possible to hide tables and other objects. It is also possible to
alias tables within a query.

To see if the tables are hidden, open up the database window and in the menu
select Tools: Options
Select the View Tab
Click on Show: Hidden Objects
Click OK. That will show any hidden tables.

If the query contains tables with an alias
Open the query in design mode
Switch to SQL mode and in the FROM clause see if the table name looks something like

SELECT ...
FROM OriginalTableName NewName
INNER JOIN AnotherOriginalTable SecondName
....

OR perhaps

SELECT ...
FROM OriginalTableName as NewName
INNER JOIN AnotherOriginalTable as SecondName
....

In the query grid, you will see NewName and SecondName as the table names.

Another possibility is that these are not Tables, but are queries - so check the
query tab of the database also.
 
thanks john! all of the tables in the query are hidden. even the Option
menu is hidden so i had to add it.
 
Back
Top