>I get a [Run-time error '3256': Index file not found] when trying to access a FoxPro 3.0 table using VB5. I have created a setup file with the extension .INF and stored it in the same directory as the FoxPro table. I have even named it the same name as the FoxPro table. I have tried using .NDX, .IDX, .MDX and .CDX extensions in the .INF file. Nothing makes a difference, I still get the same error.
>
>This is the code I am using:
>
>set DB=DBEngine.Workspaces(0).OpenDatabase(sDBPATH,True,False,sDBTYPE)
>set RS=DB.OpenRecordset(sDBNAME, dbOpenTable)
>
>This is the structure of my .INF file:
>
>[FoxPro 3.0]
>CDX1=INDEX1.CDX
>CDX2=INDEX2.CDX
>CDX3=INDEX3.CDX
>CDX4=INDEX4.CDX
>
>Any ideas would be appreciated.
>
>Thanks,
Basically all FP tables have just one CDX file with the same name as the table. Of course this could be changed easily but since it's the most effective way and uses only one extra file handle no one would want to do. Plus this structural CDX files open by table (you don't instruct them to open - header keeps it). So I think you wouldn't put any extra thing in inf file.
Cetin