Re: Seek Method on Access97 Dbf - with ODBC Connection

Hi Sona,

I'm a little confused by the "Dbf" in your subject line. Are you working in
Access against a FoxPro (or other) DBF that is linked via ODBC? The FoxPro
ODBC driver does not support the Xbase SEEK or INDEX commands. Doug is right
that you would need to SQL select a row using criteria in a WHERE clause.

What exactly are you trying to accomplish?

--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@xxxxxxxxxxxxxxxxxxx


"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: ASP.NET 1.1 connecting to DBF
    ... Which "ODBC for DBF" are you using? ... NTX index files makes me think yours are not FoxPro files (they have CDX ...
    (microsoft.public.sqlserver.connect)
  • Re: Word mail merge with foxpro
    ... I did come across an article about using FoxPro with earlier Word ... > The dbf is not attached to a dbc as I have always found that more ... The MDAC 2.5 installaion helpded greatly I am just a bit worried ... >> is to switch on ODBC logging in the ODBC administrator. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Foxpro and crystal 9 - data location at runtime
    ... crpDatabaseTables.ConnectionProperties.Add "SourceDB", strNewLocation ... I suspect that the property to set is very dependant on the odbc driver that ... properties available and none are for the database location. ... > My reports use an ODBC connection to the foxpro data. ...
    (microsoft.public.vb.crystal)
  • Re: Word 07 mailmerge source using dbf
    ... > Be great if you have first hand knowledge that dbf will work with 07. ... Because the OLE DB provider and ODBC driver may return some data - date, numeric, logical and perhaps even text - in different formats, you may need to make a decision as to whether you are going with OLE where it is available or sticking with ODBC. ... .dbf is still listed as a format in the list of formats in Word 2007's Select Data Source dialog box ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Linking to ODBC in A2003 aborts
    ... Do you have an ODBC driver for FoxPro installed? ... Server I'd have to buy a new computer and install Access on it. ... It's really easy to connect to those tables in A97. ...
    (comp.databases.ms-access)