Access 2k linking to a FoxPro 2.6 table...

[MarkB2]

An application was written a few years ago to link to various FoxPro 2.6 tables. It linked to these tables and then used a query to pull the information for various reports. Corporate wants everyone on Access 2k or better for support. We have one machine which has Access 97 just so it can link to the FoxPro tables. Obviously the newer Access applications cannot be run on this PC.

How can I link to the FoxPro 2.6 tables?

Microsofts jet engine no longer links to the FoxPro 2.6 tables. Without rewritting this monster what options has any of you come up with?

TIA
Mark

 

[JonFer]

I believe you can link a FoxPro table using the Dbase IV or V driver. I don't know if it supports the indexes but it should.


John

http://www.interautomateconsulting.com

 

[MarkB2]

Unfortunately the application they are linking to are 2.6 for windows. I do not know how to make them a DBase version IV or higher without crashing the owner application.

Is there a way to install an older version of the jet engine, or a different way to access the FoxPro 2.6 tables I am not aware of?

Thanx
Mark

 

[PHV]

Have you tried all the VFP ODBC drivers ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[MarkB2]

I created an ODBC driver using the "Microsoft Visual FoxPro Driver (*.dbf)", setting database type to "Free Table" and pointing to the directory containing the tables.

I then link the tables using an ODBC connection, selecting the table and specifying the update key.

Using the ODBC method, the queries are taking extreemly long. A query that previously ran in 1 or 2 minutes now takes 30 minutes. I assume that the query is not able to use the FoxPro 2.6 index to streamline the execution.

Does anyone have a suggestion on how to speed this up?

TIA
Mark

 

[JonFer]

Mark - You don't convert the tables to DBase, you just use the Dbase driver to set up the link.


John

http://www.interautomateconsulting.com