DOCUMENT:Q166113  31-JUL-2001  [visualc]
TITLE   :PRB: User-defined Modules Can't Be Used Through ODBC or DAO
PRODUCT :Microsoft C Compiler
PROD/VER:4.0 4.1 4.2 5.0 6.0
OPER/SYS:
KEYWORDS:kbProgramming kbDAOsearch kbDatabase kbMFC kbODBC kbVC

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Visual C++, versions 4.0, 4.1 
 - Microsoft Visual C++, 32-bit Enterprise Edition, versions 4.2, 5.0, 6.0 
 - Microsoft Visual C++, 32-bit Professional Edition, versions 4.2, 5.0, 6.0 
 - Microsoft Visual C++, 32-bit Learning Edition, version 6.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 kbvc400 kbvc410 kbvc420 kbvc500 kbvc600

======================================================================
Keywords          : kbProgramming kbDAOsearch kbDatabase kbMFC kbODBC kbVC 
Technology        : kbVCsearch kbVC400 kbAudDeveloper kbVC410 kbVC420 kbVC500 kbVC600 kbVC32bitSearch kbVC500Search
Version           : 4.0 4.1 4.2 5.0 6.0
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.

Copyright Microsoft Corporation 2001.