Re: Seek Method on Access97 Dbf - with ODBC Connection

Seek only works with table-type recordsets. This is true of all versions of
Access, so upgrading won't make any difference.

The Access 97 Help file has the following comment in it:

"In an ODBCDirect workspace, the Find and Seek methods are not available on
any type of Recordset object, because executing a Find or Seek through an
ODBC connection is not very efficient over the network. Instead, you should
design the query (that is, using the source argument to the OpenRecordset
method) with an appropriate WHERE clause that restricts the returned records
to only those that meet the criteria you would otherwise use in a Find or
Seek."

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Sona Karthikeyan" <Sona.tvm@xxxxxxxxx> wrote in message
news:1165869554.873579.236460@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


Application trying to develop in VB6 and Access97 Database.
Connected through ODBC - dsn Connnection to the Server Database


Seek and Index methods rises and error message that Provider not
support this Method.


Can any one sugest and solution.. rather than suggesting me to update
Access97 Database

Thank you



.

Loading