Note The information in this topic applies only to a Microsoft Access database (.mdb).
When Microsoft Office Access 2003 generates dependency information, it ignores one or
more objects for the following reasons:
Insufficient permission
You don't
have permission to open an object in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.). Access 2003 needs to open,
save, and close an object to generate dependency information for it. To get
permissions for one or more objects in the database, contact the owner of the
database.
Unsupported objects
Access 2003
uses name maps created by the name AutoCorrect feature to generate dependency
information. Objects such as action queries and SQL-specific queries, including union queries, data-definition queries, pass-through queries, and subqueries, do not support the Name AutoCorrect (Name AutoCorrect: A feature that automatically corrects common side effects that occur when you rename forms, reports, tables, queries, fields, or controls on forms and reports. However, Name AutoCorrect cannot repair all references to renamed objects.)
feature, so dependency information for such objects cannot be generated. Due to this limitation, the dependency information you are viewing may not be complete.