The information in this article applies to:
SYMPTOMS
The Microsoft Access ODBC Driver does not support multiple result sets of native Access tables. Calling SQLGetInfo( hdbc, SQL_MULT_RESULT_SET, ... ) returns an 'N' signifying the driver does not support multiple result sets. This means an application cannot call the ActiveX Data Objects (ADO) ADODB.Recordset.NextRecordset method when using the Microsoft OLE DB Provider for ODBC Drivers and the Microsoft Access ODBC Driver. Do not use the ADODB.Recordset.NextRecordset method with the Microsoft Access ODBC Driver or any other driver that does not support multiple result sets. STATUSThis behavior is by design. REFERENCESMicrosoft Jet Database Engine Programmer's Guide Additional query words: resultset, Access, ADO
Keywords : kbDatabase kbODBC |
Last Reviewed: May 1, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |