Article ID: 189448
Article Last Modified on 6/30/2006
APPLIES TO
- Microsoft Data Access Components 2.0
- Microsoft Data Access Components 2.5
- Microsoft Data Access Components 2.6
- Microsoft Active Server Pages 4.0
- Microsoft ActiveX Data Objects 1.5
- Microsoft Internet Information Server 4.0
This article was previously published under Q189448
SYMPTOMS
When you use an Active Server Pages (.asp) page and ActiveX Data Objects
(ADO) to open a recordset from a query in a Microsoft Access database,
which contains any intrinsic functions (for example, Month(), Left(),
etc.), the following error may occur:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access 97 Driver] Undefined function
'xxxxx' in expression.
CAUSE
This behavior occurs when the following conditions are true:
- The Vbajet32.dll file is version 5.0.0.7122 (ships with Visual C++ 5.0, Visual Studio Service Pack 2 and Service Pack 3) or later (MDAC 2.0
currently ships with version 6.1.8167).
- The Visual Basic 5.0 run-time library is version 05.00.4319 (Service
Pack 2 or Service Pack 3)
- The Visual Basic 5.0 run-time library is loaded into memory. In essence,
a Visual Basic component (compiled after Service Pack 2 or Service Pack
3) has been loaded into memory.
The behavior occurs because of a bug in the Visual Basic 5.0 run-time
library, the Msvbvm50.dll file, version 5.1.43.19 (Service Pack 2 or
Service Pack 3). The bug does not show up unless Vbajet32.dll is version
5.0.0.7122 or later.
RESOLUTION
This bug has been fixed in the Visual Basic 6.0 run-time library. If you
have Visual Basic 6.0 installed, recompile your Visual Basic 5.0 components
in Visual Basic 6.0. If you do not have Visual Basic 6.0 installed, you can
replace the Vbajet32.dll file version 5.0.0.7122 with file version 3.0.0.6098 that ships with Microsoft Data Access Components (MDAC) version 1.5. The file can be downloaded as a part of the MDAC 1.5 install from the following Web site:
NOTE: After you replace the Vbajet32.dll file with the 3.0.0.6098 version, you need to reboot the Web server.
STATUS
This has been fixed in Visual Basic version 6.0.
Additional query words: error 80040e14
Keywords: kbbug kbfix kbvbp600fix kbmdacnosweep KB189448