Access2000 & FoxPro

[duklaprague]

Hi,

I have recently upgraded from Access 97 to Access 2000 at work.

Before the upgrade I used Access to Front End FoxPro(v2.6) tables. However, since upgrading, when I try to link the Foxpro tables into Access, they appear to be read only.

Has anyone else had this problem, know of a workaround, or is it simply a tough luck wersioning issue?

Any help would be appreciated.

Cheers,
Iain

 

[jhall156]

How are you linking? Are you using ODBC or the fox pro ISAM? JHall

 

[duklaprague]

Hi,

Not sure (I'm not too technical) - how can I tell?

Basically I have Access open, and go to File>Get External Data>Link Tables and from there just link to the FoxPro Table. Like I say - it worked before, so can't think why it shouldn't now unfortunately....


Cheers,
Iain

 

[jhall156]

what did the little icon next to the table look like before? JHall

 

[duklaprague]

Hi,

As far as I remember it used to be the little red fox icon, whereas now its just a more generic black "db" icon.

Any ideas?

Iain

 

[jebry]

Hi!

Can you upgrade your FoxPro tables to Visual FoxPro? I don't think A2k recognizes FoxPro.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[evalesthy]

This has been the source of a lot of controversy. Originally MS released Access so that only Reading of linked dbase tables was allowed. They told customers to buy the Borland Database Engine BDE which we did and it worked. I think in later releases you no longer have to buy the BDE. For starters see
"

http://www.microsoft.com/Data/MDAC21info/MDAC21GAmanifest.htm"

 

[duklaprague]

Hi,

Thanks for the suggestions. I had thought it should be OK, as there is an option for dBASEIV when you try to link a table (which I thought was FoxPro).

Jeff - when you say A2K doesn't recognize FoxPro, would it still link the table as read only?

Evalesthy - when you say later releases no longer require BDE - is that later releases of Access or FoxPro? As it is a later version of Access than I had previously (2K over 97 - which worked fine).

TIA,
Iain

 

[Sindo]

Microsoft have removed direct support for ISAM linked Foxpro tables from Access 2000-2002, we had a similar problem here when we upgraded.

Microsoft will tell you that you now have to setup an ODBC Data Source and then link it that way. However we found this option can be very slow with the older foxpro tables (v2.6)

Sindo

 

[jebry]

Hi!

We haven't been able to get them to read the tables at all. But we haven't tried much since the source of the FoxPro database is upgrading to Oracle and we are just running dual systems until it is done.

Jeff Bridgham
bridgham@purdue.edu