Linking Access 2003 to FoxPro Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Wells - 29 Oct 2004 08:49 GMT

Having a problem linking Access 2003 to a FoxPro database. Have read the bits
in the knowledgebase about using Visual FoxPro ODBC to link instead of
linking directly. The only snag is I can't seem to load the FoxPro ODBC
driver in Windows XP. Checking this out I seem to be directed to use the
"Microsoft OLE DB Provider for Visual FoxPro" I can download this but can't
see any way of getting it to work.

Any suggestions gratefully received.

Paul Wells

Reply to this Message

Cindy Winegarden - 30 Oct 2004 21:03 GMT

Hi Paul,

Which version of the VFP ODBC driver are you trying? The latest is
downloadable from
http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx . What
happens when you try to install it?

Signature

Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com

> Having a problem linking Access 2003 to a FoxPro database. Have read the
> bits
[quoted text clipped - 8 lines]
>
> Paul Wells

Reply to this Message

Paul Wells - 01 Nov 2004 19:04 GMT

Thanks Cindy,

The problem was that the VFP ODBC driver wasn't loaded and I couldn't find
the download. From the link you gave I've now installed the driver and have
sucessfully linked to the database. Closer examination shows I just wasn't
scrolling quite far enough down the web page where it lists the ODBC driver!
Thanks again.

Paul

> Hi Paul,
>
[quoted text clipped - 15 lines]
> >
> > Paul Wells

Reply to this Message

Paul Wells - 01 Nov 2004 19:07 GMT

Thanks Cindy,

Using the link you gave I've now downloaded the ODBC driver and have
successfully linked to the FoxPro tables.

Thanks for the help
Paul Wells

> Hi Paul,
>
[quoted text clipped - 15 lines]
> >
> > Paul Wells

Reply to this Message