Microsoft KB Archive/918811

= 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 =

Article ID: 918811

Article Last Modified on 11/16/2007

-

APPLIES TO


 * Microsoft Office Access 2007
 * Microsoft Windows SharePoint Services 3.0

-





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 &quot;Applies to&quot; section.



MORE INFORMATION
For more information about Access 2007, visit the following Microsoft Web site:

http://office.microsoft.com/en-us/access/ha101656301033.aspx

Additional query words: AC2007 ACC2007 Access2007

Keywords: kbtshoot kbbug kbperformance kbprb kbexpertiseinter KB918811

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.