Help and Support

Article ID: 918811 - Last Review: November 16, 2007 - Revision: 2.1

A query may return corrupted data for Memo fields when you run the query against a list in Windows SharePoint Services 3.0 in Access 2007

Expand all | Collapse all

SYMPTOMS

You run an advanced query against a list in Windows SharePoint Services 3.0 from Microsoft Office Access 2007. When you do this, the query may return corrupted data for Memo fields.

CAUSE

This problem occurs when you use the GROUP BY clause on the Memo field.

WORKAROUND

To work around this problem, change the Memo field to a Text field.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about Access 2007, visit the following Microsoft Web site:
http://office.microsoft.com/en-us/access/ha101656301033.aspx (http://office.microsoft.com/en-us/access/ha101656301033.aspx)

APPLIES TO
  • Microsoft Office Access 2007
  • Microsoft Windows SharePoint Services 3.0
Keywords: 
kbtshoot kbbug kbperformance kbprb kbexpertiseinter KB918811

Article Translations