Index
2007-10-04 10:42 – Philip Borkholder : using Access to open VFP 9 DBC via ODBC
2007-10-04 12:04 – Tracy Pearson : RE: using Access to open VFP 9 DBC via ODBC
2007-10-05 10:07 – Charlie Coleman : RE: using Access to open VFP 9 DBC via ODBC
2007-10-05 11:37 – Tracy Pearson : RE: using Access to open VFP 9 DBC via ODBC
Back to top
using Access to open VFP 9 DBC via ODBC

Author: Philip Borkholder

Posted: 2007-10-04 10:42:58   Link

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

---

©2007 Philip Borkholder
Back to top
RE: using Access to open VFP 9 DBC via ODBC

Author: Tracy Pearson

Posted: 2007-10-04 12:04:46   Link

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 Tracy Pearson
Back to top
RE: using Access to open VFP 9 DBC via ODBC

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

©2007 Charlie Coleman
Back to top
RE: using Access to open VFP 9 DBC via ODBC

Author: Tracy Pearson

Posted: 2007-10-05 11:37:05   Link

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

©2007 Tracy Pearson