object dependency task pane in access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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>
 
Back
Top