Check your Excel Template’s LIMSAccessVersion

If you began using LIMS prior to version 4.0 and you use Excel templates in your implementation, it is likely that one or more of your templates include a LIMSAccessVersion setting. An improper value for the LIMSAccessVersion option in the template’s Settings worksheet may cause unexpected errors or incomplete exports to the template. Occasionally a template with an incorrect LIMSAccessVersion setting will work properly on one workstation but will fail on another.

When you export an LIMS report to an Excel template, in some cases only part of the report’s data is actually exported to Excel. Some Excel templates, such as those designed for the Sample Summary report, query the LIMS for additional data. To perform the query, Excel must establish communication with the LIMS. The LIMSAccessVersion setting identifies the internal version number of the Microsoft Access version used by LIMS. The Excel template’s macro uses the Access version number to locate the running instance of LIMS, which is particularly important on workstations that may also be running other versions of Microsoft Access.

We recommend checking all of the Excel templates you use regularly. If the template includes the LIMSAccessVersion setting, make sure it is set to the correct Microsoft Access version number, which is 10 for LIMS 3.x and 14 for LIMS 4.x.