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.