sendtojp
asked on
I need the a ODBC Driver for FoxPro (or Visual) for Access
I am an Access Developer and need to Link to FoxPro Tables in Access. I am tring to fix a Access '97 with the Linked Tables not working. The files that are linked to the Tables are *.dbf. I get the folowing message when tring the Links 'could not find installabale ISAM'.
Please help
-JP
Please help
-JP
The ODBC driver for VFP does not come in MDAC any longer.
Try this link for a free ODBC download:
Visual FoxPro ODBC Driver
http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx
There is also freely downloadable OLE DB Provider for VFP if you want to go that way:
Microsoft OLE DB Provider for Visual FoxPro
http://www.microsoft.com/downloads/details.aspx?FamilyId=0F43EB58-7A94-4AE1-A59E-965869CB3BC9&displaylang=en
Try this link for a free ODBC download:
Visual FoxPro ODBC Driver
http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx
There is also freely downloadable OLE DB Provider for VFP if you want to go that way:
Microsoft OLE DB Provider for Visual FoxPro
http://www.microsoft.com/downloads/details.aspx?FamilyId=0F43EB58-7A94-4AE1-A59E-965869CB3BC9&displaylang=en
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have I answered your question?
ASKER
In the case of the Links in the Access '97 Database, I am still unable to open directly, or re-link these Tables, and it still displays the same ISAM error. I am now able however to make new Links under the ODBC drivers, which function without problems. The technology behind appears different from what was used in the Links in the Access '97 Database. However the VB Application which uses these Links seems to see these Links just fine. I suppose that this is fine. I seem to be intergrating with alot of Applications lately, so I guess I just want to be able to establish new Links to any FoxPro Database (Visual and 2.0,2.5,2.6).
One issue, I decovered, while tring to link to a FoxPro database was that opening a Table in Access behaves strangely when adding and update records, with duplicate records being added and some updates not 'sticking'. This was almost a year ago, and I have reinstalled Windows since then. Is there a way to see if I will have this problem in the future (i.e. samples of each version on the Internet.).
Thank You for all your help,
-JP
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Do you have a FoxPro Database (2.0,2.5,2.6)
dBASE, FoxPro, Clipper
I wish I can try these out?
-JP
There were multiple questions here, I will post another question to give you more points. Check back for the link.
dBASE, FoxPro, Clipper
I wish I can try these out?
-JP
There were multiple questions here, I will post another question to give you more points. Check back for the link.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
CarlWarner,
Thank you so much for your help, sorry I tought I accepted your answer already.
-JP
Thank you so much for your help, sorry I tought I accepted your answer already.
-JP
No problem.
I'm glad I could throw a lot of relevant things your way.
I'm glad I could throw a lot of relevant things your way.
ASKER
win XP Pro
Access 2000 and Access 2003 installed
MDAC 2.8 was installed already