Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Incorrect object dependencies information appears for database objects in a read-only database
Article ID: 826760 - View products that this article applies to.
This article applies only to a Microsoft Access database (.mdb).
Novice: Requires knowledge of the user interface on single-user computers.
When you open an Access database as read-only, and then you try to view the object dependencies for database objects (such as a table), the incorrect object dependencies may be listed.
Access builds the dependency list based on name maps. This problem occurs when the database object has been recently renamed, and the name change has not been updated. By default, if the database is opened as read-only, the Track name AutoCorrect info feature and the Perform name AutoCorrect feature are not available. You cannot make these features available.
To work around the problem, open the database in read mode or in write mode. If the Perform name AutoCorrect feature is not enabled, follow these steps to enable this feature:
Track name AutoCorrect info is a feature that was introduced in Microsoft Access 2000. When the Track name AutoCorrect info feature is made available for the database, Access creates the name map for each database object, and then keeps track of name changes. However, this feature does not perform any corrections.
To make name changes throughout the database, the Perform name AutoCorrect feature must be made available. When you open an object, Access checks to see if a name change must be applied to that object or to its contents. If a change has occurred, Access makes the required name change automatically.
For the Perform name AutoCorrect feature to work correctly, the object that has the name change made to it must have a name map that is associated with it. If the object does not have a name map, the Perform name AutoCorrect feature cannot repair the name change for the object even though the Perform name AutoCorrect feature is enabled to track and to perform the name change.
Steps to Reproduce the ProblemCaution If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
For more information about renaming errors and object dependencies, click Microsoft Office Access Help on the Help menu, type Name AutoCorrect in the Search for box in the Assistance pane, and then click Start searching to view the topic.