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
- Open the sample database Northwind.mdb.
- On the Tools menu, click Options. Click the General tab. Click to select the three check boxes under Name AutoCorrect. Click OK.
- Open the Customers table in Design view. Change the Address field name to AddressNew. Save and close table.
- Open and then close the Orders form. Microsoft Access creates the Name AutoCorrect Log table and adds six records.
- Open the Name AutoCorrect Log table in Datasheet view. Note the existing records.
- Select the Property Name column. On the Format menu, click Rename Column. Type Source, and then press ENTER. Close the table.
- Open the Customers table in Design view. Change the CompanyName field name to CompanyNameNew. Save and close table.
- Open and then close the Orders form.
- 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.
- Select the Source column. On the Format menu, click Rename Column. Type Property Name, and then press ENTER. Close the table.
- Open the Customers table in Design view. Change the City field name to CityNew. Save and close table.
- Open and then close the Orders form.
- 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