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