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.

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


View products that this article applies to.

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.

↑ Back to the top


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.

↑ Back to the top


Keywords: commercialoff2010track, kbprb, kbsurveynew, kbpubtypekc, kbexpertiseadvanced, kberrmsg, kb

↑ Back to the top

Article Info
Article ID : 983126
Revision : 3
Created on : 9/21/2018
Published on : 9/21/2018
Exists online : False
Views : 333