Name AutoCorrect doesn't fix references in:
-
A replicated database. When you replicate your database, Access turns Name AutoCorrect off. You can't turn on Name AutoCorrect in a database Design Master or replica.
-
Pass-through, data-definition, and union queries.
-
Data access pages, macros, and modules.
- Desktop shortcuts that open a particular database object.
- An invalid SQL statement.
- Microsoft Visual Basic code.
- A linked table when the table or fields have been renamed in the back end of a front-end/back-end database.
- The Filter or OrderBy properties of tables, queries, forms, and reports.
In addition, Name AutoCorrect doesn't fix references to macros in a toolbar or menu, including menu and toolbar properties and event properties that are set to macro names.
If you import or create a database object when Name AutoCorrect is not turned on, Access doesn't have enough information to enable NameAutoCorrect for that object. To enable Name AutoCorrect for the object, do the following:
- On the Tools menu, click Options, and then click the General tab.
- Select the Track name AutoCorrect info and Perform name AutoCorrect check boxes.
If you want a log of the changes that Access makes to the database when it repairs naming errors, select the Log name AutoCorrect changes check box as well.
- Open the database object in Design view, save it, and close it.
Name AutoCorrect doesn't work in a converted database.
Microsoft Name AutoCorrect is on by default in databases that were created with Microsoft Access 2000 or later. Name AutoCorrect is automatically turned on when you convert databases created using Access 97 or earlier to Access 2003 . If Name AutoCorrect is not enabled in a converted database, do the following:
- On the Tools menu, click Options, and then click the General tab.
- Select the Track name AutoCorrect info and Perform name AutoCorrect check boxes.
If you want a log of the changes that Access makes to the database when it repairs naming errors, select the Log name AutoCorrect changes check box as well.
Name AutoCorrect doesn't work for imported objects.
When you import an object into an Access 2000 or later database that has tracking enabled, the tracking information is not automatically updated for the imported objects. You must save and close the objects to enable tracking. If you import objects into an Office Access 2003 database, the tracking information for the imported objects are automatically updated.