Troubleshoot viewing dependency information (MDB)

Microsoft Office Access 2003

Microsoft Office Access 2003 generates dependency information by searching the name maps maintained by the Name AutoCorrect feature. You cannot view dependency information in the following situations:

ShowTracking name AutoCorrect information is turned off.

If this feature is turned off, Access 2003 cannot search the name maps, so it cannot generate dependency information. Turn on this feature to create name maps for the objects in the database.

  • Select Track name AutoCorrect info check box on the General tab in the Options dialog box.

Note  To have Access 2003 run name AutoCorrect as name changes occur in the database, select the Perform name AutoCorrect check box.

ShowName maps are missing.

If one or more name maps are missing, the dependency information generated by Access 2003 will not be complete.

Do one of the following:

  • Turn on name AutoCorrect if it is disabled by selecting Track name AutoCorrect info check box on the General tab in the Options dialog box.
  • If name maps are missing when name AutoCorrect is already turned on, it could be because the name map creation process was interrupted. To restart the process of creating name maps, clear the Track name AutoCorrect info check box, click Apply, then select the check box again.

ShowName maps cannot be created or updated.

To create or update a name map, Access 2003 must open, save, and close each object in the database. If an object is already open but has unsaved changes, or is read-only, or if you don't have permissions to open and save an object, name maps will not be created or updated.

  1. Make sure you have permissions to save objects.
  2. Close all objects.
  3. Restart the process of creating name maps. Clear the Track name AutoCorrect info check box, click Apply, then select the check box again.

ShowDependency information for new unsaved objects cannot be generated.

An object must be saved at least once before you can view its dependency information. Access creates a name map for the object when it is saved. If the object that is currently open in Design view is new, and has not been saved yet, you will see an error message prompting you to save the object. Save the object, and then try displaying the dependency information.