Microsoft KB Archive Search

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.

  1. Home
  2. 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

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

View products that this article applies to.

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.

↑ Back to the top

Cause

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

↑ Back to the top

Workaround

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

↑ Back to the top

Status

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

↑ Back to the top

More information

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

↑ Back to the top

Keywords: KB918811, kbexpertiseinter, kbprb, kbperformance, kbbug, kbtshoot

↑ Back to the top

Article Info
Article ID : 918811
Revision : 3
Created on : 11/16/2007
Published on : 11/16/2007
Exists online : False
Views : 325