RE: using Access to open VFP 9 DBC via ODBC

Author: Charlie Coleman

Posted: 2007-10-05 at 10:07:15

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

©2007 Charlie Coleman