MSQuery: Can't Use Views with User-Defined Functions

 Last reviewed: September 12, 1996
Article ID: Q139572
The information in this article applies to:
  • Microsoft Query for Windows, version 1.0

SUMMARY

When you use a Microsoft Access data source in Microsoft Query, you receive the following error message when you add a view from the Add Tables dialog box to the Table pane 

   Undefined function '<function name>' in expression
where <function name> is the name of a custom function you defined.

MORE INFORMATION

In Microsoft Access, you can define a custom (user-defined) function that takes one or more arguments and returns a result that can be used in an expression, such as a SELECT statement. In Microsoft Query, a Microsoft Access query is called a "View," and it returns a result set in a tabular format. A view can be selected from the Add Tables dialog box and added to the Data pane. If the view is based on a SELECT statement containing a user- defined function, the error message in the "Summary" section of this article will be displayed.

REFERENCES

For more information on working with views, click the Search button in Help and type "views" or "Table Options Dialog Box."

KBCategory: kbinterop
KBSubcategory: xlquery

Additional reference words: 1.00 2.00



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.