Re: Seek Method on Access97 Dbf - with ODBC Connection


For an attempt I tried to connect with out ODBC!!!! Same error!! So
shall i come in a conclution that it wont work with Access database!!




Douglas J. Steele wrote:
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


.

Relevant Pages

  • Re: Mail merge process is printing out extra records
    ... FWIW I can easily replicate this problem here with some simple test data. ... when it connects to a Jet database by specifying properties in a .odc (or ... is to use an ODBC connection instead of an OLEDB one (check Word ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Passing parameter to a select query
    ... ' need to wait while the first query refreshes ... it works fine for external linking of the database within Access. ... you have an ODBC connection for your database? ...
    (microsoft.public.excel.programming)
  • Re: creating replication and not using default database name
    ... the datawh and has the db name in the ODBC connection. ... that when I've started replication before. ... > of the subscriber database name is. ... I am going to break and recreate replication to our datawarehouse. ...
    (microsoft.public.sqlserver.replication)
  • Re: Insert database problem
    ... In my experience, the Database field works fine as long as you ... Assuming all machines have the required Oracle ODBC driver installed, ... be able to force the ODBC connection by going directly over MS Query (from the ...
    (microsoft.public.word.tables)
  • RE: Linking Access f/e to Access b/e via ODBC
    ... > My objective was to use an ODBC connection to connect a local f/e to a ... able to use your database. ... > and execute queries on the server. ... See http://www.Access.QBuilt.com for Microsoft Access tips. ...
    (microsoft.public.access.externaldata)
Loading