Help and Support

PRB: Access ODBC Driver Does Not Support Multiple Result Sets

View products that this article applies to.
Article ID:202433
Last Review:September 17, 2003
Revision:2.0
This article was previously published under Q202433

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.

Calling the NextRecordset method returns error 800A0CB3:
The operation requested by the application is not supported by the provider.
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.

Back to the top

STATUS

This behavior is by design.

Back to the top

REFERENCES

Microsoft Jet Database Engine Programmer's Guide

Back to the top

APPLIES TO
•Microsoft Data Access Components 1.5
•Microsoft Data Access Components 2.0
•Microsoft Data Access Components 2.1
•Microsoft Data Access Components 2.5
•Microsoft Open Database Connectivity Driver for Access 4.0
•Microsoft Open Database Connectivity Driver for Access 1.0
•Microsoft Open Database Connectivity Driver for Access 2.0
•Microsoft Open Database Connectivity Driver for Access 3.0
•Microsoft Open Database Connectivity Driver for Access 3.5
•Microsoft Open Database Connectivity Driver for Access 3.6

Back to the top

Keywords: 
kbdatabase kbprb kbmdacnosweep KB202433

Back to the top

Article Translations

 

Other Support Options

  • Contact Microsoft
    Phone Numbers, Support Options and Pricing, Online Help, and more.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.