Turning On Name AutoCorrect in a Converted Access Database 
Name AutoCorrect automatically corrects common problems that occur when you rename forms, reports, tables, queries, fields, or controls on forms and reports. However, this feature is not turned on by default in a converted Microsoft Access database. To turn on Name AutoCorrect in a converted Access database - On the Tools menu, click Options, and then click the General tab.
- On the General tab, do any of the following:
- To have Access maintain the information it needs to run Name AutoCorrect, but not take any action, select the Track name AutoCorrect info check box.
- To have Access perform Name AutoCorrect as name changes occur in the database, select the Perform name AutoCorrect check box.
- To have Access keep a log of the changes it makes each time it runs Name AutoCorrect, select the Log name AutoCorrect changes check box. Access saves the changes in a table called Name AutoCorrect Log. Each change is a record in the Name AutoCorrect Log table.
- Open each table, query, form, and report in Design view, save the object, and close it.
Note Name AutoCorrect can't repair all references to renamed objects; for example, it doesn't correct expressions in macros or in Visual Basic® for Applications (VBA) procedures in modules. Also, Name AutoCorrect can't repair references in data access pages; however, an Access database that you have just converted from a previous version doesn't contain data access pages. For more information, type name autocorrect in the Office Assistant or on the Answer Wizard tab in the Help window, click Search, and then click "What Name AutoCorrect fixes and doesn't fix in an Access database."
|
