Linking to Visual Foxpro V7+ from Access - ODBC no longer works

[sschabel]

Hi All.
I have a MS Access 2003 database that links to visual foxpro tables using
ODBC. The VFP tables are now version 8 and as the 3rd party vendor adds
newer features I lose the ability to use the current MS VFP ODBC driver to
access that data. I have seen posts to use OLE or ADO, but I do not know how
to link tables in Access using them. The VFP tables are not in a container
(dbc) file -- they are free tables. How can I re-link them?
Thanks!

 

[Cindy Winegarden]

Hi!

Basically, you can't link the tables. You can only access them via OLE DB
and ADO. You'll have to take this issue up with your vendor.

 

[sschabel]

Thank you -- not the answer I hoped for, but thanks anyway. Any suggestions
for a work-around?