Access Tip: Use the AppendOnly Property and the ColumnHistory Method to Keep Historical Data for Memo Fields

In Access 2007-Format databases (ACCDBs), the AppendOnly property for Memo fields allows you to store a history of the changes made to the field. The history of the Memo field can later be retrieved using the ColumnHistory method.