Microsoft KB Archive/195293

= BUG: Code Profiler Add-In Gives Errors With Project Using ADO =

Article ID: 195293

Article Last Modified on 11/18/2003

-

APPLIES TO


 * Microsoft Visual Basic 5.0 Learning Edition
 * Microsoft Visual Basic 5.0 Professional Edition
 * Microsoft Visual Basic 5.0 Enterprise Edition

-



This article was previously published under Q195293



SYMPTOMS
When trying to use the Visual Basic Code Profiler DLL with a project that utilizes ADO, the following compiler error message will be returned from the "VBCP_Startup" subroutine found in VBCPCODE.BAS module:

Method or Data Member Not Found

The Visual Basic Compiler will be referring to the "index" property of the mtblVBCPTbl Recordset object.



CAUSE
The Visual Basic Code Profiler (VBCP) uses DAO to perform the profiling. When it is used in a project that contains ADO, the declarations of Recordset get created as ADO Recordsets and therefore cause the error.



RESOLUTION
The workaround is to use DAO as a prefix to all the Database and Recordset declarations in the vbcpcode.bas module as in the following:

Dim mdbVBCPDB As DAO.Database Dim mtblVBCPTbl As DAO.Recordset Dim recTmp As DAO.Recordset



STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

Keywords: kbbug kbaddin kbcompiler KB195293

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.