Handling Errors for Access

iFIX provides the SQLERR.TXT text file, located in the C:\Program Files (x86)\Proficy\iFIX\App directory, to help you troubleshoot communication errors from your relational database. This file contains communication error numbers. When a communication error occurs, iFIX displays @ symbols (by default) in a data link to indicate the problem.

If you are using Access, some of the same error numbers listed in the SQLERR.TXT file are used to indicate relational database errors. As a result, you may see @ symbols in the run-time environment when no communication error has occurred. To correct this problem, delete the SQLERR.TXT file.