Problem Linking Foxpro 9 .DBC in Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to link a Foxpro 9 .DBC into Access 2003.

I can choose:
Link
ODBC Databases
Machine Data Source
User Data Source
Microsoft Visual Foxpro Driver
and then select the Visual FoxPro database .DBC location.

I then am able to select specific tables in the .DBC, but when I try to link
them I get the error:
Could not execute query; could not find linked table.
[Microsoft][ODBC Visual Foxpro Driver] Not a table. (#123)

Any suggestions?
 
Hi Frank,

Here's some information I posted elsewhere:

Over time, new data features have been added to FoxPro DBFs. DBFs that are
in the old Fox2x or dBASE format can be opened natively by Access. Visual
FoxPro DBFs created with VFP6 and below (and also Fox2x tables) can be
opened via ODBC. If there is a DBC file present, point your ODBC connection
to it, otherwise use the "free" table option. DBFs having new data features
added in VFP7 and above can only be accessed in code using OLE DB and ADO.
DBFs created with VFP7 and above that don't have any of the new data
features are still ODBC compatible.

When you say your DBC is a "FoxPro 9" DBC, do you know if it has any of the
new data features? The "Not a table" error is typical of what happens when
the ODBC driver tries to open a table and finds that it's in an incompatible
format such as a table having the new VFP7+ data features.


--
Cindy Winegarden
(e-mail address removed)


VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
 
Thanks for your response Cindy.

I am sure the DBC has Foxpro 7+ features as the vendor that produces this
software just made a major upgrade and went from a Foxpro 6 file stucture to
Foxpro 9 file structure. I don't think they would do this other than to take
advantage of advanced features.

I have installed the OLE DB provider on my workstation but don't see any way
to reference it in Access to import or link the tables in the DBC. Perhaps it
has to be installed on the server where the database resides. Can you point
me to a document somewhere that explains this? I am not a programmer so am a
bit handicapped here.

Kind regards,
Frank

Cindy Winegarden said:
Hi Frank,

Here's some information I posted elsewhere:

Over time, new data features have been added to FoxPro DBFs. DBFs that are
in the old Fox2x or dBASE format can be opened natively by Access. Visual
FoxPro DBFs created with VFP6 and below (and also Fox2x tables) can be
opened via ODBC. If there is a DBC file present, point your ODBC connection
to it, otherwise use the "free" table option. DBFs having new data features
added in VFP7 and above can only be accessed in code using OLE DB and ADO.
DBFs created with VFP7 and above that don't have any of the new data
features are still ODBC compatible.

When you say your DBC is a "FoxPro 9" DBC, do you know if it has any of the
new data features? The "Not a table" error is typical of what happens when
the ODBC driver tries to open a table and finds that it's in an incompatible
format such as a table having the new VFP7+ data features.


--
Cindy Winegarden
(e-mail address removed)


VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx




Frank schaner said:
I am trying to link a Foxpro 9 .DBC into Access 2003.

I can choose:
Link
ODBC Databases
Machine Data Source
User Data Source
Microsoft Visual Foxpro Driver
and then select the Visual FoxPro database .DBC location.

I then am able to select specific tables in the .DBC, but when I try to
link
them I get the error:
Could not execute query; could not find linked table.
[Microsoft][ODBC Visual Foxpro Driver] Not a table. (#123)

Any suggestions?
 
Hi Frank,

As I said below:

In other words, you can't link the tables. You can only access them in code.

--
Cindy Winegarden
(e-mail address removed)


VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx




Frank schaner said:
Thanks for your response Cindy.

I am sure the DBC has Foxpro 7+ features as the vendor that produces this
software just made a major upgrade and went from a Foxpro 6 file stucture
to
Foxpro 9 file structure. I don't think they would do this other than to
take
advantage of advanced features.

I have installed the OLE DB provider on my workstation but don't see any
way
to reference it in Access to import or link the tables in the DBC. Perhaps
it
has to be installed on the server where the database resides. Can you
point
me to a document somewhere that explains this? I am not a programmer so am
a
bit handicapped here.

Kind regards,
Frank

Cindy Winegarden said:
Hi Frank,

Here's some information I posted elsewhere:

Over time, new data features have been added to FoxPro DBFs. DBFs that
are
in the old Fox2x or dBASE format can be opened natively by Access. Visual
FoxPro DBFs created with VFP6 and below (and also Fox2x tables) can be
opened via ODBC. If there is a DBC file present, point your ODBC
connection
to it, otherwise use the "free" table option. DBFs having new data
features
added in VFP7 and above can only be accessed in code using OLE DB and
ADO.
DBFs created with VFP7 and above that don't have any of the new data
features are still ODBC compatible.

When you say your DBC is a "FoxPro 9" DBC, do you know if it has any of
the
new data features? The "Not a table" error is typical of what happens
when
the ODBC driver tries to open a table and finds that it's in an
incompatible
format such as a table having the new VFP7+ data features.


--
Cindy Winegarden
(e-mail address removed)


VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx




message
I am trying to link a Foxpro 9 .DBC into Access 2003.

I can choose:
Link
ODBC Databases
Machine Data Source
User Data Source
Microsoft Visual Foxpro Driver
and then select the Visual FoxPro database .DBC location.

I then am able to select specific tables in the .DBC, but when I try to
link
them I get the error:
Could not execute query; could not find linked table.
[Microsoft][ODBC Visual Foxpro Driver] Not a table. (#123)

Any suggestions?
 
Frank,

I have the same problem and would like to know if you were able to
solve your situation. You may be using the same software/vendor I'm using.
I'm using Access 2003 and wanted to link to tables from a VFP 9 database.

Thank you.

Abraham.

Frank schaner said:
Thanks for your response Cindy.

I am sure the DBC has Foxpro 7+ features as the vendor that produces this
software just made a major upgrade and went from a Foxpro 6 file stucture to
Foxpro 9 file structure. I don't think they would do this other than to take
advantage of advanced features.

I have installed the OLE DB provider on my workstation but don't see any way
to reference it in Access to import or link the tables in the DBC. Perhaps it
has to be installed on the server where the database resides. Can you point
me to a document somewhere that explains this? I am not a programmer so am a
bit handicapped here.

Kind regards,
Frank

Cindy Winegarden said:
Hi Frank,

Here's some information I posted elsewhere:

Over time, new data features have been added to FoxPro DBFs. DBFs that are
in the old Fox2x or dBASE format can be opened natively by Access. Visual
FoxPro DBFs created with VFP6 and below (and also Fox2x tables) can be
opened via ODBC. If there is a DBC file present, point your ODBC connection
to it, otherwise use the "free" table option. DBFs having new data features
added in VFP7 and above can only be accessed in code using OLE DB and ADO.
DBFs created with VFP7 and above that don't have any of the new data
features are still ODBC compatible.

When you say your DBC is a "FoxPro 9" DBC, do you know if it has any of the
new data features? The "Not a table" error is typical of what happens when
the ODBC driver tries to open a table and finds that it's in an incompatible
format such as a table having the new VFP7+ data features.


--
Cindy Winegarden
(e-mail address removed)


VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx




Frank schaner said:
I am trying to link a Foxpro 9 .DBC into Access 2003.

I can choose:
Link
ODBC Databases
Machine Data Source
User Data Source
Microsoft Visual Foxpro Driver
and then select the Visual FoxPro database .DBC location.

I then am able to select specific tables in the .DBC, but when I try to
link
them I get the error:
Could not execute query; could not find linked table.
[Microsoft][ODBC Visual Foxpro Driver] Not a table. (#123)

Any suggestions?
 
I have the same problem and would like to know if you were able to
solve your situation. You may be using the same software/vendor I'm
using.
I'm using Access 2003 and wanted to link to tables from a VFP 9 database.


Hi Abraham,

As I posted earlier (>> > ) FoxPro tables that use any of the new data
features added in VFP7 and above are not compatible with ODBC, and thus you
can't link them in Access. They are only compatible with OLE DB and you must
access them in code using ADO.


--
Cindy Winegarden
(e-mail address removed)

VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
 
Cindy,

Thank you for your response. I'm not an expert and don't know what ADO
or OLE DB actually means and how to write code. Do you know of a product
that can I can purchase that will let me connecto thru a wizard ?. Please
advise.

Thank you.

Abraham.
 
Back
Top