ACC2000: Changes Not Tracked in Name AutoCorrect Log Table

MORE INFORMATION

   Field Name        Data Type
   ---------------------------
   Object Type       Text
   Object Name       Text
   Control Name      Text
   Property Name     Text
   Old Value         Memo
   New Value         Memo
				

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.