Attempting to link a table with Microsoft Access or Excel fails with the error:
ODBC--call failed. [TOD][ODBC][GENESIS]WORM: Cannot open 'GENESIS_XCOLUMNS',Too many open files (#-3)
The problem can be fixed by setting MAX_FILES to a higher number in the AcuXDBC configuration file. The system catalog is a set of Vision files and each open can use up to 16 files.
The default is 32, so opening up 2 DSNs causes the MAX_FILES default setting to be exceeded resulting in the error.