INFO: Limitations of IRowsetIndex::Seek() Used with Jet database (258576)


The information in this article 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.

REFERENCES

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

258580 Seek.exe Demonstrates How to Use IRowsetIndex Methods Seek, SetRange, and GetIndexInfo

Modification Type:MajorLast Reviewed:12/5/2003
Keywords:kbDatabase kbinfo kbJET KB258576
©2003 Microsoft Corporation. All rights reserved.