DOCUMENT:Q195293  06-NOV-1998  [vbwin]
TITLE   :BUG: Code Profiler Add-In Gives Errors With Project Using ADO
PRODUCT :Microsoft Visual Basic for Windows
PROD/VER:WINDOWS:5.0
OPER/SYS:WINDOWS
KEYWORDS:kbVBp500bug kbAddIn kbCompiler

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

 - Microsoft Visual Basic Learning, Professional, and Enterprise Editions
   for Windows, version 5.0
---------------------------------------------------------------------

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.

Additional query words:
======================================================================
Keywords          : kbVBp500bug kbAddIn kbCompiler
Version           : WINDOWS:5.0
Platform          : WINDOWS
Issue type        : kbbug

=============================================================================

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 1998.