Q2795 ODBC error - Index file missing

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'.

Solution:

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.