Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 924678 - Last Review: October 15, 2007 - Revision: 1.4
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
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.
This behavior is by design.
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
- Start Access 2007.
- In the New Blank Database section, click Blank Database, and then click Create.
- On the Create tab, click Table.
- Click the Microsoft Office Button, and then click Save to save the table.
- In the Table Name box, type MemoTable, and then click OK.
- In the Navigation Pane, right-click MemoTable, and then click Design View.
- In the Field Name column, type MemoField. Then, in the Data Type column, click Memo.
- Under Field Properties, set the Append Only property to Yes.
- Click the Microsoft Office Button, and then click Save.
- Create a history for a record. To do this, commit several values to the Memo field in a single record.
- In the Navigation Pane, right-click MemoTable, and then click Design View.
- Click MemoField.
- Under Field Properties, set the Append Only property to No.
- Click the Microsoft Office Button, and then click Save to save the table changes.
APPLIES TO
- Microsoft Office Access 2007
| kbinfo kbtshoot kbdatabase kbprb kbdesign kbexpertiseinter KB924678 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate