Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 258576 - Last Review: December 5, 2003 - Revision: 4.1
INFO: Limitations of IRowsetIndex::Seek() Used with Jet database
This article was previously published under Q258576
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.
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.
For additional information, click the article number below
to view the article in the Microsoft Knowledge Base:
258580Â
(http://kbalertz.com/Feedback.aspx?kbNumber=258580/EN-US/
)
Seek.exe Demonstrates How to Use IRowsetIndex Methods Seek, SetRange, and GetIndexInfo
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
| kbdatabase kbinfo kbjet KB258576 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate