Microsoft KB Archive/201923

= ACC2000: Changes Not Tracked in Name AutoCorrect Log Table =

Article ID: 201923

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q201923



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: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow 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.

