Applies To:
  • CitectSCADA 3.xx, 4.xx, 5.xx

I have a DBF file that was created in Access which I'm now trying to link to via ODBC. The configuration worked during testing but once the project went out on site I got SQL error code: 5111 'Index File Missing'.  

When Access creates a DBF file, it hard codes the location of the Index file into its .INF file. If the DBF file is restored into a different directory on the Runtime PC and the ODBC setting are then correctly configured to match the new location of the file, you will experience this error because the INF file is pointing to the wrong location for the Index file.

If you open the DBF file under Acces on the Runtime PC it will update the INF file and enter the correct path information.