Incorrect object dependencies information appears for database objects in a read-only database (826760)

MORE INFORMATION

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 Problem

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

1. Start Access.
2. Open the Northwind.mdb database in read mode or in write mode.
3. In the Database window in the Objects section, click Tables.
4. View the Object Dependencies of the Suppliers table. To do this, follow these steps:
   1. Right-click the Suppliers table, and then click Object Dependencies.
   2. In the Object Dependencies pane for the table, view the list of database objects with the following criteria:
      • Objects that depend on me
      • Objects that I depend on
5. Rename the Suppliers table to Suppliers1.
6. Close the Northwind.mdb database.
7. Open the Northwind.mdb database as read-only. To do this, follow these steps:
   1. Start Access.
   2. On the File menu, click Open.
   3. In the Open dialog box, select the database that you want.
   4. On the Open button, click the down arrow, and then select Open Read-Only.
8. In the Database window under Objects, click Tables.
9. View the Object Dependencies of the Suppliers1 table. To do this, follow these steps:
   1. Right-click the Suppliers1 table, and then click Object Dependencies.
   2. In the Object Dependencies pane for the table, view the list of database objects with the following criteria:
      • Objects that depend on me
      • Objects that I depend on
        
        Notice that the database objects that are listed in the Object Dependencies pane are incorrect.
10. In the Database window under the Objects section, click Forms.
11. In the right pane, double-click Suppliers.
    
    Notice that when you try to open the Suppliers form, the form does not open, and you receive the following error message:
    The record source 'Suppliers' specified on this form or report does not exist.
    
    You misspelled the name, or it was deleted or renamed in the current database, or it exists in a different database.
    
    In the Form or Reports Design view, display the property sheet by clicking the Properties button, and then set the RecordSource property to an existing table or query.
    Note You receive this error message when the name changes are not made. The database object is still dependent on the previous object dependencies.