Knowledge Base

BUG: Selecting RecordSource for Data Control Causes VB to Hang

Article ID: 191787

Article Last Modified on 1/8/2003

APPLIES TO

This article was previously published under Q191787

SYMPTOMS

Trying to access an Excel spreadsheet by using the Data Control and Excel ODBC Driver causes Visual Basic to hang.

RESOLUTION

Using the Excel ISAM driver with the Data Control works correctly.

STATUS

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

MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a DSN that points to an Excel spreadsheet using the Microsoft Excel ODBC driver. Name the DSN MyExcel.
  2. Create a Standard EXE Project in Visual Basic. Form1 is created by default.
  3. Place a Data Control on Form1.
  4. For the Data Control's Connect Property, enter the following:

    ODBC;DSN=MyExcel
  5. Scroll down to the RecordSource property of the Data Control.
  6. Drop down the ComboBox for this property. Note that Visual Basic hangs.

Additional query words: kbDAO350bug kbExcel kbVBp500bug kbJET kbIISAM kbODBC kbdse kbDSupport kbVBp

Keywords: kbbug KB191787


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.