Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Access
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
About ignored objects (MDB)
 

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:

ShowInsufficient 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.

ShowUnsupported 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.

advertisement