Problem linking a FoxPro 5.0 table

[mhaff]

I've done this several times before with no problem.
Here's what I do.
I have MS Access 2000 open with no existing tables.
I click "Get External Data" then "Link Table".
I browse to the table I want which was created in Visual FoxPro 5.0.
It has a dbf extension so I select dBase 5 in the "Files of type" drop down.
I double click the file and it links without a problem.
This worked just a couple of days ago.

Today when I try the same procedure, after selecting the dbf file Access prompts
me to select an index file of type ndx or mdx. Well, FoxPro uses a cdx file for indexes.
Even if I manually enter the cdx file name, it still wants an ndx or mdx. If I click cancel
it will tell me that the table was successfully linked but if I try to open it I get the error:
"Index file not found".

I wasn't even being prompted for and index file before today.
The only thing different on my computer from the last time is that
I installed VB6 but that shouldn't affect Access. Or would it?

Suggestions?

 

[johnnymac43]

Guess it must. I have VB6 on my machine and have never been able to link to Foxpro tables as you describe. (That is how I link to dBASE tables).

For Foxpro I use the following:

> ODBC databases
> Machine Data Source
> Foxpro Files - Word
> Free table directory
> Select your data directory and follow the prompts from there. (You will have to select a Unique Record Identifier for each table you attach).

HTH

John