FMS Home Page

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

FMS Development Team Blog

Exploring the Latest in Application Development

Home Archive Contact Subscribe Sign in

About FMS

FMS, Inc. is software development company in Tyson's Corner, VA.

Send mail

Recent posts

Microsoft Access Database Architecture: Taking Time into Account and Shadow TablesComments: 0
FMS Guest Blogs on the Microsoft Access Developer Blog: Using a Combo Box to SearchComments: 0
Microsoft Access Database Architecture: Storing Temporary Data and User SettingsComments: 0
Preserve Your Free 25GB Microsoft SkyDrive Account before it Becomes 7GBComments: 1
Microsoft Access versus Microsoft Excel for Data Analysis and ReportingComments: 0
Impact Aid Survey Form Software for Federal Education FundingComments: 0
Total Access Analyzer Ships for Microsoft Access 2010Comments: 0
Microsoft Access Form Selecting the First Item in a ComboBox or ListBoxComments: 0
Microsoft Access Forms with Cascading Combo Boxes and List BoxesComments: 0
The Hot Mommas Project Website UpdateComments: 0

Recent comments

Preserve Your Free 25GB Microsoft SkyDrive Account before it Becomes 7GB (1)
Bill Mosca wrote: Thanks for the heads-up, Luke. While I doubt if I'… [More]
Transposing Data in Microsoft Access Tables and Data Normalization (2)
FMS Support wrote: Vito, Your comment is not related to this blog,… [More]
Transposing Data in Microsoft Access Tables and Data Normalization (2)
Vito Pheasant wrote: I have a quick question. I have a sysprep file for… [More]

Authors

Blogroll

Download OPML file OPML

OPML

© Copyright 2012 FMS, Inc.

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.

Currently rated 5.0 by 4 people

Currently 5/5 Stars.
1
2
3
4
5

Categories: Microsoft Access | Microsoft Office

Posted by Molly on Friday, October 16, 2009 3:26 PM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (0) | Post RSS RSS comment feed

RSS comment feed

Related posts

Office Tip: Introducing Microsoft Office/Access 2010 and SkyDriveIntroducing Microsoft Office/Access 2010 and SkyDriveTotal Access Analyzer Ships for Microsoft Access 2010 Microsoft Access Database Documentation and Analysis 300 Ways To Create Better Microsoft Acc...Microsoft Access Tip: Problems Converting a Database in Access 2007 from ACCDB to MDBFrom Access 2007, you may want to convert an Access ACCDB database to a legacy MDB format. You may h...

Comments are closed