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.

Unexpected behavior occurs when you perform certain calculations in a field or in a column in a published Access 2010 Web database


View products that this article applies to.

Symptoms

Consider the following scenario. You have a Microsoft Access 2010 Web database that is published to a Microsoft SharePoint Server 2010 Web site that has Access Services enabled. When you perform certain calculation operations in a field or in a column in the database in this scenario, unexpected behavior occurs. For example, when you filter a field for a certain date, data that does not match the applied filter is displayed. This problem occurs when the following conditions are true:
  • The data type of the field or of the column is Date/Time.
  • The Time zone setting on the computer that is hosting the Web site does not match the Time zone setting in the SharePoint regional settings.

↑ Back to the top


Cause

Some actions are evaluated in the computer context. Such actions include certain macros, expressions, or validation rules. However, other actions, such as data macros or calculated columns, are evaluated in the SharePoint regional settings context. This mismatch causes the problem.

↑ Back to the top


Resolution

To resolve this problem, make the Time zone setting on the computer match the Time zone setting in the SharePoint regional settings. To do this, you can change either of the settings. To change the Time zone setting in the SharePoint Server 2010 Web site, follow these steps:
  1. Open the site that has the Time zone setting that you want to change.
  2. Click the Site Actions list, and then click Site Settings.
  3. Under the Site Administration section, click Regional settings.
  4. On the Time zone list, select the time zone that you want to change to, and then click OK.
The steps to change the Time zone setting on a computer vary, depending on the operating system. For example, to change the Time zone setting on a computer that is running Windows Vista, follow these steps:
  1. Click Start
    , type timedate.cpl in the Start Search box, and then press ENTER.
    If you are prompted for an administrator password or for confirmation, type the password, or provide confirmation.
  2. On the Date and Time tab, click Change time zone.
  3. On the Time zone list, select the time zone that you want to change to.
  4. Click OK two times.

↑ 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


Keywords: KB981862, kbprb, kbsurveynew, kbexpertiseadvanced, kbtshoot

↑ Back to the top

Article Info
Article ID : 981862
Revision : 4
Created on : 5/17/2010
Published on : 5/17/2010
Exists online : False
Views : 45