ACC2000: Changes Not Tracked in Name AutoCorrect Log Table

ID: Q201923

The information in this article applies to:
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).


SYMPTOMS

The Name AutoCorrect Log table may not track all changes even if you have selected all of the check boxes in the Name AutoCorrect area.


CAUSE

This behavior occurs if you change one or more of the field names in the Name AutoCorrect Log table to something other than the default name.


RESOLUTION

Change the names of the fields in the Name AutoCorrect Log table back to the original names.


MORE INFORMATION

The original field names and data types for the Name AutoCorrect Log table are: 


   Field Name        Data Type
   ---------------------------
   Object Type       Text
   Object Name       Text
   Control Name      Text
   Property Name     Text
   Old Value         Memo
   New Value         Memo
CAUTION: Following the steps in this example will modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and perform these steps on a copy of the database.

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.


  2. On the Tools menu, click Options. Click the General tab. Click to select the three check boxes under Name AutoCorrect. Click OK.


  3. Open the Customers table in Design view. Change the Address field name to AddressNew. Save and close table.


  4. Open and then close the Orders form. Microsoft Access creates the Name AutoCorrect Log table and adds six records.


  5. Open the Name AutoCorrect Log table in Datasheet view. Note the existing records.


  6. Select the Property Name column. On the Format menu, click Rename Column. Type Source, and then press ENTER. Close the table.


  7. Open the Customers table in Design view. Change the CompanyName field name to CompanyNameNew. Save and close table.


  8. Open and then close the Orders form.


  9. Open the Name AutoCorrect Log table in Datasheet view. There will still only be six records. If the field name had not been changed in step 6, there would be two additional records in the table.


  10. Select the Source column. On the Format menu, click Rename Column. Type Property Name, and then press ENTER. Close the table.


  11. Open the Customers table in Design view. Change the City field name to CityNew. Save and close table.


  12. Open and then close the Orders form.


  13. Open the Name AutoCorrect Log table in Datasheet view. There are now two new records.



REFERENCES

For more information about changing field names in a table, click Microsoft Access Help on the Help menu, type "change a field name in a table" in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

For more information about the Name AutoCorrect feature not tracking changes, click Microsoft Access Help on the Help menu, type "what Name AutoCorrect fixes and doesn't fix in an Access database" in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: prb 


Keywords          : kbdta 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 13, 1999