Re: Foxpro - VB - Access what do I need?

Cindy,

First, thanks for all your help so far.

I currently have Visual Foxpro driver version 6.01.8629.01 installed. I
created a DSN and used it to link to one of the Foxpro tables to an Access
97 DB. This particular table only has about 500 records. It takes the
linked table over 14 minutes to display and then Access locks up.

I've tried to install the newer driver from MS's website, but when I launch
the install program, a dialog box flashes too fast for me to read and the
program quits.

Any ideas on how to fix these problems? Or, if I can't get odbc to work,
can you give me an example of an ADO connect string that will allow me to
read and write to these tables? Thanks again.

Best,

Jim

"Cindy Winegarden" <cindy_winegarden@xxxxxxx> wrote in message
news:%23YC9KHTPFHA.2356@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Jim,
>
> Which ODBC driver were you using when you used VFP6 tables and Access? The
> Jet ODBC driver won't work with tables that have any of the newer data
> features; you'll need to use the VFP ODBC driver, downloadable from
> http://msdn.microsoft.com/vfoxpro/downloads/updates.
>
> From there you need to create an ODBC data source and link to the tables
> using the ODBC data source. Get as far as you can, and post back if you
> have more questions.
>
> --
> Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
> cindy_winegarden@xxxxxxx www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
>
> "James Houston" <houstjd@xxxxxxxxx> wrote in message
> news:OMNSigHPFHA.2568@xxxxxxxxxxxxxxxxxxxxxxx
>> 3. After manipulation, the data is then appended to an application that
>> uses Foxpro 2.0 tables. The Foxpro tables are linked to the Access 97 db
>> via ODBC. Therein lies my problem.
>>
>> The Foxpro app in this scheme has to be upgraded to a newer version that
>> uses Foxpro 6 tables. I've tried to get FP6 to talk to Access 97 via
>> ODBC in the past, and couldn't get it to work. Ditto using ADO. Now
>> that I'm being forced to upgrade, I'm getting ready to try it again. The
>> first two links in this chain, the DOS and Access 97 apps will remain
>> largely unchanged. Just to make sure I've got everything set up
>> correctly can someone tell me what I'll need to to read and write to a
>> Foxpro table via ODBC? The Foxpro tables are free tables with CDX style
>> indexes.
>
>


.

Relevant Pages

  • Re: Linking to ODBC in A2003 aborts
    ... Do you have an ODBC driver for FoxPro installed? ... Server I'd have to buy a new computer and install Access on it. ... It's really easy to connect to those tables in A97. ...
    (comp.databases.ms-access)
  • Re: Access import off Fox Pro Tables
    ... I am having an issue installing the visual fox pro driver. ... and try to install from the link you provided, I am getting the error "The ... How can I get this VFP odbc driver? ... > Start with the latest ODBC driver for FoxPro and Visual FoxPro, ...
    (microsoft.public.access.externaldata)
  • Re: Link Visual Fox Pro 8.1 to Access 2003
    ... Visual FoxPro driver, select the folder with the data files and access ... Later versions of MDAC don't have the VFP ODBC driver. ... Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP ... > keep getting the error "You must first install the current version of the> Visual FoxPro ODBC Drive. ...
    (microsoft.public.access.externaldata)
  • Re: Still having problems merging with DBF
    ... works for older .dbf format files, whereas the FoxPro driver is for more ... see if you can open the DBF in Excel using the FoxPro ... you almost certainly need to install the Jet stuff ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Could not find instalable ISAM
    ... That error happens when the driver does not exist. ... I think you are going to have to add the text driver to the installed driver set for ODBC in the Office setup. ... > I hit system DSN and hit add. ... > everything i could check on from custom install method) ...
    (microsoft.public.windowsxp.help_and_support)