Automatically repair errors caused by renaming (MDB)

Microsoft Office Access 2003

Show All Show All

Automatically repair errors caused by renaming (MDB)

Note  The information in this topic applies only to a Microsoft Access database (.mdb).

  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.

Notes

  • If you want to view dependency information for a table, query, form, or report, you must select the Track name AutoCorrect info check box. This option creates or updates the name maps that are necessary for generating dependency information.
  • If the Track name AutoCorrect info check box is selected, and you encounter errors when trying to view dependency information, make sure you have permission to save and close objects. Also try clearing the check box, clicking Apply, and then reselecting the Track name AutoCorrect info check box.