ODBC - Tables vs. Queries

[chazgaz]

I currently have 2 Access databases that are completely separate from one another. I have an ODBC set up for each database so I can run some Crystal Reports.

My question is related to what fields are available to me when I make my ODBC connection through Crystal Reports.

Database 1 - Only the tables are visible when I connect through Crystal

Database 2 - Only the queries are visible when I connect through Crystal

Why can't I see my queries in Database 1 and why can't I see my tables in Database 2?

In Database 1, I am trying to report on fields that are part of my queries.

Is there some sort of property in Access that establishes what is visible (tables and/or queries) when an ODBC connection is made?

 

[cheerio]

When you link to a database using MSquery at the time you get to see the list of tables you might choose from there is an options button which allows the choice of tables, views or both.