If the LIMS application is accessed through Citrix, there might be difficulties in installing or upgrading Microsoft Access Databases (*.mdb).
Issue:
Even after creating a ODBC connection in the LIMS server, while trying to execute, RUN -> DBMT or RUN -> INSTALL MODULE, the new ODBC connection is not listed.
Solution:
When LIMS is accessed via Citrix environment, ODBC connection should be created in the Citrix Server.
Even if there is no access to the Citrix server, run the following LIMS Basic command,
Execute("odbcad32")
This command will open up the ODBC administrator dialog for the Citrix server.
Create a User DSN pointing to the new mdb file.
Now, try running 'DBMT' or 'INSTALL MODULE'.
The new ODBC connection will be listed and can be used.
