Cindy
Thu Sep 11 21:31:44 CDT 2003
Hi Branislav,
The latest ODBC driver is available from
http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx. The
latest VFP OLE DB provider is available from
http://microsoft.com/downloads/details.aspx?FamilyId=0F43EB58-7A94-4AE1-A59E-965869CB3BC9&displaylang=en.
Over the years, new features have been added to FoxPro tables. The ODBC
driver will handle any table which only has features that were available in
VFP6 (and below). It does not handle any of the new features that were added
in VFP7 or VFP8, although you can read tables from a VFP8 application as
long as they don't have any of the new features. If you try to read a table
with the new features using the ODBC driver you'll get the "Not a table"
error you describe.
To be able to read tables having the new VFP7 and VFP8 features you need to
use the OLE DB provider.
Another situation where the "Not a table" error crops up is if a table (of
any FoxPro version) is corrupt. For a discussion of what to do about that
problem see
http://fox.wikis.com/wc.dll?Wiki~NotATable.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org, www.cindywinegarden.com
"Branislav Maletic" <bmaletic@tdm-consulting.com> wrote in message
news:110701c378c7$9296b080$a501280a@phx.gbl...
> I need to access VFP8 tables from VC++; I can see that
> there is a Visual Fox Pro ODBC Driver for Database and
> Tables that comes with Microsoft Data Access Components
> 2.8 but when I try to use the driver through Microsoft
> Access (link the tables) I get the following error
>
> Could not execute query;could not find linked table.
> [Microsoft][ODBC Visual FoxPro Driver]Not a table (#123).
>
> Is the driver that comes with MDAC 2.8 reliable or should
> I use something else (any other commercial or shareware
> product)?
>
> THANKS!