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 process a data collection e-mail reply when the query that the e-mail was based on contains an Access 2007-defined function


View products that this article applies to.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access database (.accdb).
Novice: Requires knowledge of the user interface on single-user computers.

↑ Back to the top


Symptoms

You cannot process a data collection e-mail reply when the query that the e-mail was based on contains a Microsoft Office Access 2007-defined function, such as the PlainText function in Access 2007. The e-mail reply does not process automatically into Access 2007, even if you select this option. You may notice that the data collection status in Microsoft Office Outlook 2007 displays the following information:
Failure: Undefined function 'FunctionName' in expression.
Note FunctionName represents the name of the function that you use in the query.

Additionally, you receive the following error message if you manually process the data collection:
Cannot export data due to errors. Failure: Undefined function 'FunctionName' in expression.

↑ Back to the top


Cause

This problem occurs because the query contains an Access-defined function, such as the PlainText function. This problem occurs even though the expression field that contains the Access 2007-defined function is not in the e-mail.

↑ Back to the top


Workaround

To work around this problem, remove the reference to the Access-defined function, or remove the field that contains the function call from the query.

↑ Back to the top


Keywords: KB918584, kbprb, kbtshoot, kbexpertisebeginner

↑ Back to the top

Article Info
Article ID : 918584
Revision : 2
Created on : 11/3/2006
Published on : 11/3/2006
Exists online : False
Views : 192