BUG: Selecting RecordSource for Data Control Causes VB to Hang (191787)


The information in this article applies to:

  • Microsoft Visual Basic Enterprise Edition for Windows 5.0
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.
Modification Type:MinorLast Reviewed:1/8/2003
Keywords:kbbug KB191787
©2002 Microsoft Corporation. All rights reserved.