[AccessD] ODBC Problems - resending

I got the ODBC set up for Foxpro I think.  For some reason, I can no longer connect to any ODBC data source in Access and my attempts to fix it have failed.

Debbie Elam
214-437-6285


-----Original Message-----
From: Jack and Pat <drawbridgej at sympatico.ca>
Sent: Sunday, May 04, 2008 9:49 AM
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Subject: Re: [AccessD] ODBC Problems - resending

Attachment got dropped so here is the text.

Jack
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Tuesday, May 16, 2006 2:29 PM
To: Access Developers discussion and problem solving
Subject: Import Foxpro into Access

You cannot connect directly to FoxPro databases in Access 2003

http://support.microsoft.com/?kbid=824264

You maybe skipping this step

3. In the Administrative Tools window, double-click Data Sources (ODBC),
and then add a new ODBC data source for your FoxPro database or tables
by selecting the appropriate Visual FoxPro driver. 

Rocky Smolin - Beach Access Software wrote:

>Dear List:
>
>I've got a bunch of FoxPro dbf files and their corresponding CDX files 
>I'm trying to link or import into an access database. In the import 
>there are dbase 'files of type' but that doesn't work.  The import 
>wizard looks for .ndx files which I think are the dbase index files.  
>Has anyone done this before?
>
>MTIA,
>
>Rocky
>
>  

-----Original Message-----
From: Jack and Pat [mailto:drawbridgej at sympatico.ca] 
Sent: Sunday, May 04, 2008 6:45 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] ODBC Problems

Debbie,
I'm not a Foxpro user, but I did find a post from Marty that may be relevant
to you. Attached is his message.

jack


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie Elam
Sent: Saturday, May 03, 2008 8:05 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] ODBC Problems

I am trying to import data from a really ancient Foxpro database.  I was
creating an ODBC connection and got an error.  As the message suggested, I
reinstalled the Foxpro driver.  Now I get nothing when I try to connect to
any ODBC data source.  When I choose odBC the pop up just dissappears.  I
have tried reinstalling MDAC to no avail.  I have also bought a repair
utility that fails in the middle of working.  Any ideas on how to repair
this?

I am using Access 2003 and XP sp2.

Debbie Elam



[The entire original message is not included]