Microsoft KB Archive/258576

= INFO: Limitations of IRowsetIndex::Seek Used with Jet database =

Article ID: 258576

Article Last Modified on 12/5/2003

-

APPLIES TO


 * Microsoft OLE DB Provider for Jet 4.0
 * Microsoft Data Access Components 2.1
 * Microsoft Data Access Components 2.5
 * Microsoft Data Access Components 2.6

-



This article was previously published under Q258576



SUMMARY
You can use IRowsetIndex::Seek to quickly search an indexed column. The Jet 4.0 OLE DB provider natively supports the IRowsetIndex interface, while the Microsoft SQL Server OLE DB Provider, Microsoft OLE DB Provider for Oracle, and other Microsoft OLE DB providers do not currently support this interface.

See the "References" section of this article for more information on how to use the Seek method.



MORE INFORMATION
In order to successfully use the Seek method with a Jet database, you must meet the following conditions:
 * You must use the Jet 4.0 OLE DB provider (CLSID_JETOLEDB_4_00).
 * The database must be in Jet 4.0 (Microsoft Access 2000) format. Although Jet 4.0 can open Access 9x databases, IRowsetIndex::Seek isn't supported with those formats.
 * You must use the IOpenRowset interface to open the rowset (IRowset). IRowsetIndex::Seek is not supported if the rowset is created any other way (such as through the use of Command::Execute).

NOTE: The information in this article also applies to applications that use the Seek method on an ActiveX Data Objects (ADO) recordset. In order to determine if an ADO recordset supports Seek, use the Supports method. See the ADO documentation on Seek for more information.

