Error Linking to VFP Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Running Access 2003, trying to link to Visual FoxPro tables through ODBC, I
get this error:

Could not execture the query; could not find linked table.
[Microsoft][ODBC Visual FoxPro Driver] Not a table.(#123)

The ODBC data source is using the MS VFP driver, referencing a database
rather than a free table directory.

Help...
 
Hi Danny,

Over time new data features have been added to FoxPro tables. Features added
through VFP6 are compatible with the FoxPro and Visual FoxPro ODBC drivers.
Features added in VFP7 and above are only compatible with OLE DB, although
tables created with VFP7+ that don't use any of the new features will still
be compatible with ODBC.

To access data via OLE DB you will need to write code to use ADO recordsets.
You can't import or link to the tables directly.

--
Cindy Winegarden
(e-mail address removed)


VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
 
Hi Cindy, and thanks for the reply. In all that I was reading, I was
understanding that this connection had to be done through code, not through
the link table wizard.

I've just looked for some code samples and can't find any; any ideas would
be helpful.

Ciao.

Cindy Winegarden said:
Hi Danny,

Over time new data features have been added to FoxPro tables. Features added
through VFP6 are compatible with the FoxPro and Visual FoxPro ODBC drivers.
Features added in VFP7 and above are only compatible with OLE DB, although
tables created with VFP7+ that don't use any of the new features will still
be compatible with ODBC.

To access data via OLE DB you will need to write code to use ADO recordsets.
You can't import or link to the tables directly.

--
Cindy Winegarden
(e-mail address removed)


VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx




Danny said:
Running Access 2003, trying to link to Visual FoxPro tables through ODBC,
I
get this error:

Could not execture the query; could not find linked table.
[Microsoft][ODBC Visual FoxPro Driver] Not a table.(#123)

The ODBC data source is using the MS VFP driver, referencing a database
rather than a free table directory.

Help...
Click to expand...
Click to expand...
 
Back
Top