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

Article translations Article translations
Article ID: 981299 - View products that this article applies to.
Expand all | Collapse all

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.

CAUSE

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

STATUS

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

WORKAROUND

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

Properties

Article ID: 981299 - Last Review: September 17, 2011 - Revision: 5.0
APPLIES TO
  • Microsoft Access 2010
Keywords: 
kbtshoot kbsurveynew kbprb KB981299

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com