Microsoft KB Archive/924678

= 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 =

Article ID: 924678

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office 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.



STATUS
This behavior is by design.



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.

Additional query words: AC2007 ACC2007 Access2007

Keywords: kbinfo kbtshoot kbdatabase kbprb kbdesign kbexpertiseinter KB924678

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.