Knowledge Base

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

Article ID: 195293

Article Last Modified on 11/18/2003

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