Microsoft KB Archive/918584

= 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 =

Article ID: 918584

Article Last Modified on 11/3/2006

-

APPLIES TO


 * Microsoft Office Access 2007

-





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.



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 ' ' in expression.

Note  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 ' ' in expression.



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.



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.

Additional query words: AC2007 ACC2007 Access2007

Keywords: kbexpertisebeginner kbtshoot kbprb KB918584

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.