Help and Support
 

powered byLive Search

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.
Article ID:918811
Last Review:November 16, 2007
Revision:2.1

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 (http://office.microsoft.com/en-us/access/ha101656301033.aspx)

Back to the top

APPLIES TO
•Microsoft Office Access 2007
•Microsoft Windows SharePoint Services 3.0

Back to the top

Keywords: 
kbtshoot kbbug kbperformance kbprb kbexpertiseinter KB918811

Back to the top

Article Translations

 

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.