PRB: User-defined Modules Can't Be Used Through ODBC or DAO

 Last reviewed: August 7, 1997
Article ID: Q166113
The information in this article applies to:
  • Microsoft Visual C++, 32-bit Editions, versions 4.0, 4.1, 4.2, 5.0

SYMPTOMS

Using Microsoft Access, you can create code modules in an .mdb file that can be used by predefined queries. When you open the query in Access, the code works as expected. However, if you use ODBC or DAO to access the predefined query, the following error message appears: 

   Undefined function '<function name>' in expression
For example, assume that a function, called PlusTen, that adds 10 to some value is defined in Access as follows: 

   Public Function PlusTen(ByVal inVal As Long) As Long
     PlusTen = inVal + 10
   End Function
You could have the following SQL statement in a predefined query: 

   Select PlusTen(column1) from table1
With the Access 7.0 or Access 97 ODBC Drivers included with Visual C++ versions 4.x and Visual C++ version 5.0, you receive an error similar to the following: 

   Undefined function 'PlusTen' in expression
   State:37000, Native:-3102, Origin:[Microsoft][ODBC Microsoft Access 97
   Driver]
If you use DAO 3.0 (included with Visual C++ 4.x) or DAO 3.5 (included with Visual C++ 5.0), the following message appears in the Output window of the debugger: 

   DAO Call Failed.
       m_pQueryDef->m_pDAOQueryDef->OpenRecordset(
         COleVariant((long)m_nOpenType), COleVariant((long)m_nOptions),
         &m_pDAORecordset)
       In file daocore.cpp on line 3327
       scode = 800A0C0D
   Error Code = 3085
   Source = DAO.Database
   Description = Undefined function 'PlusTen' in expression.

CAUSE

ODBC and DAO do not use or know anything about the code modules inserted into an .MDB file by Access. Only Access recognizes the modules.

STATUS

This behavior is by design.

Additional query words: Jet
Keywords : dbDao MfcDAO MfcDatabase kbprg
Version : 4.0 4.1 4.2 5.0
Platform : NT WINDOWS
Issue type : kbprb

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: August 7, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.