Automatically repair errors caused by renaming

1. On the Tools menu, click Options.
2. On the General tab, do one or more of the following:
   • To have Microsoft 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 run 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.
3. To enable Name AutoCorrect for a table, query, form or report that already exists in the Access database, open it in Design view, save it, and close it.