Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

When you change the value of the Append Only property to No for a Memo field in a table, the column history for the Memo field is lost in Access 2007


Symptoms

In Microsoft Office Access 2007, the Append Only property for a Memo field in a table is set to Yes. When you change the value of this property to No, the column history for the Memo field is lost.

↑ Back to the top


Status

This behavior is by design.

↑ Back to the top


More Information

When you change the value of the Append Only property to No, Access 2007 no longer tracks changes to the Memo field. Additionally, the history of all the changes to the Memo field is deleted.

Steps to reproduce this behavior

  1. Start Access 2007.
  2. In the New Blank Database section, click Blank Database, and then click Create.
  3. On the Create tab, click Table.
  4. Click the Microsoft Office Button, and then click Save to save the table.
  5. In the Table Name box, type MemoTable, and then click OK.
  6. In the Navigation Pane, right-click MemoTable, and then click Design View.
  7. In the Field Name column, type MemoField. Then, in the Data Type column, click Memo.
  8. Under Field Properties, set the Append Only property to Yes.
  9. Click the Microsoft Office Button, and then click Save.
  10. Create a history for a record. To do this, commit several values to the Memo field in a single record.
  11. In the Navigation Pane, right-click MemoTable, and then click Design View.
  12. Click MemoField.
  13. Under Field Properties, set the Append Only property to No.
  14. Click the Microsoft Office Button, and then click Save to save the table changes.

↑ Back to the top


Keywords: kbexpertiseinter, kbdatabase, kbdesign, kbentirenet, kbtshoot, kbinfo, kbprb, kb

↑ Back to the top

Article Info
Article ID : 924678
Revision : 3
Created on : 4/23/2018
Published on : 4/23/2018
Exists online : False
Views : 166