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.

You cannot publish an Access 2010 database that passes the Web compatibility check


View products that this article applies to.

Symptoms

You have a Microsoft Access 2010 database that passes the Web compatibility check. When you publish the database to a Microsoft SharePoint server, you receive the following error message:
Could not save this object's changes to the server. You canceled the previous operation.
This problem occurs when a report in the database uses an aggregate function, such as the Sum function or the Average function, in the Report Header section.

↑ Back to the top


Cause

This problem occurs because aggregate functions are not supported in the Report Header section, or in the Page Header section.

↑ 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


Workaround

To work around this problem, add the aggregate function to the Detail section.

↑ Back to the top


Keywords: KB981299, kbprb, kbsurveynew, kbtshoot

↑ Back to the top

Article Info
Article ID : 981299
Revision : 4
Created on : 5/13/2010
Published on : 5/13/2010
Exists online : False
Views : 46