General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
FoxPro Table Index Access Error
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,
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only