object dependency task pane in access 2003

[Guest]

Does anyone know why union queries are shown as an "unsupported object" in
the object dependency task pane in Access 2003?

I would look in the help files but for some reason there are none in this
installation of office.

Thanks.

Dave

 

[Brendan Reynolds]

This is what the documentation says about the limitations of the dependency
feature ...

<quote>
The dependency information is generated only for tables, queries, forms, and
reports in an Access database. It is not available for the following:


data access pages, macro, and modules in a database.
objects not supported by the name AutoCorrect feature, such as action
queries and SQL-specific queries, including union queries, data-definition
queries, pass-through queries, and subqueries.
Access projects.

Note Nested queries are partially supported. Access can generate dependency
information only for the outermost query. Also, the source tables and
queries of a query's subdatasheet and lookup fields are not listed as
objects that the query depends on.
</quote>