>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,
This sounds like a problem with the table. Can the table be opened in Foxpro without any errors. Just a guess but the CDX file is missing or corupt.
Fred Lauckner
You know, it works on my computer. I don't know what your problem is.
.Net aint so bad.