Hey All,
I've been trying to connect to VFP 9 database containers from Access and am
getting an error that does not recognize the tables as tables.
Using the ODBC Visual Foxpro Database driver.
Anyone know what to do to connect Access to VFP 9 databases?
Here's the error I get:
Could not execute query; could not find linked table.
[Microsoft][ODBC Visual FoxPro driver]Not a table.(#123)
Thanks,
Philip
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
The ODBC driver supports VFP 6 and lower. If you are using features that
have been added after that, you'll need to access the DBC and tables with
ADO.
HTH,
Tracy
-----Original Message-----
From: Philip Borkholder
Sent: Thursday, October 04, 2007 11:43 AM
Hey All,
I've been trying to connect to VFP 9 database containers from Access and am
getting an error that does not recognize the tables as tables.
Using the ODBC Visual Foxpro Database driver.
Anyone know what to do to connect Access to VFP 9 databases?
Here's the error I get:
Could not execute query; could not find linked table.
[Microsoft][ODBC Visual FoxPro driver]Not a table.(#123)
Thanks,
Philip
Author: Charlie Coleman
Posted: 2007-10-05 10:07:15 Link
Quick question Tracy, how do you set up the ADO connection? Can you provide
a quick example?
-Charlie
At 01:04 PM 10/4/2007 -0400, Tracy Pearson wrote:
>The ODBC driver supports VFP 6 and lower. If you are using features that
>have been added after that, you'll need to access the DBC and tables with
>ADO.
>
>HTH,
>Tracy
>
>-----Original Message-----
>From: Philip Borkholder
>Sent: Thursday, October 04, 2007 11:43 AM
>
>Hey All,
>
>I've been trying to connect to VFP 9 database containers from Access and am
>getting an error that does not recognize the tables as tables.
>
>Using the ODBC Visual Foxpro Database driver.
>
>Anyone know what to do to connect Access to VFP 9 databases?
>
>Here's the error I get:
>
>Could not execute query; could not find linked table.
>
>[Microsoft][ODBC Visual FoxPro driver]Not a table.(#123)
>
>
>
>Thanks,
>
>Philip
I usually reference this http://www.connectionstrings.com/
I've not used Access in years for anything then a quick glance of an MDB
before extracting it to VFP.
HTH,
Tracy
-----Original Message-----
From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com] On
Behalf Of Charlie Coleman
Sent: Friday, October 05, 2007 11:07 AM
To: profoxtech@leafe.com
Subject: RE: using Access to open VFP 9 DBC via ODBC
Quick question Tracy, how do you set up the ADO connection? Can you provide
a quick example?
-Charlie