Access Services in SharePoint Server 2010 and in Access 2010 generate different error codes for a type mismatch error

Vrijedi za: SharePoint Server 2010Access 2010

Symptoms


Consider the following scenario:
  • You have a computer that is running Microsoft SharePoint Server 2010.
  • You have Access Services enabled in SharePoint Server 2010.
  • You publish a Microsoft Access 2010 database to Access Services.
  • You add a new record to a table in the database.
  • When you add the record, you receive a type mismatch error in the USysApplicationLog:

    Category: Execution
    Context: error_expression
    Description: Type mismatch
    ErrorNumber: -8084
    ObjectType: Macro
    SourceObject: Access_table.field
  • Then, you open the database by using Access 2010 and then add a new record to the same table
  • When you add the record, you receive the following error in USysApplicationLog: 

    Category: Execution
    Object Type: Macro
    SourceObject: [Access_table].[field]
    Description: Failed to evaluate expression 'error_expression': error value '#VALUE!'.
    Error Number: -8990
    Context: error_expression
In this scenario, you notice that Access Services and the Access 2010 client generate different error codes for the type mismatch error.

Cause


This issue occurs because of the way expressions are evaluated when you use Access Services in SharePoint Server 2010 and when you use Access 2010. The error codes represent the following errors:
  • Error code-8084 is an evaluation time error.
  • Error code -8990 is a parse time error.