Error Messages

Ensure that runtime 2010 is installed, as well as all MS update patches.

Solutions: There are several possibilities permission issues for this error.

These errors suggest that the Access 2010 Runtime did not install the service pack. That can happen if the system reboots after the 2010 Runtime is installed.

We frequently receive reports that a new user login account, added in the Users screen on the Admin menu, only works on one LIMS workstation and is unrecognized on other workstations. Adding the login account again at another workstation...

We often receive questions similar to this one:

One user recently noticed that their Excel-based final reports automatically emailed by LIMS Messaging were failing for just one of their new customers with the error “Could not send with MsgExcel …” Checking the designated folder where...

SOLUTION : This error occurs when a login name exists in more than one role, which can occur if the user was added through SQL Server Management Studio.

This error can appear when starting LIMS at one workstation while other workstations may still be using the LIMS. The error occurs because Microsoft Access determines the listed database is in an inconsistent state, which is most often c...

A user called and asked why she was getting the red MIN and MAX warnings during results entry. For the analyte in question, she had set the warning max to 9 and the warning minimum to 8 in the Analyses setup screen, which were also the v...

When querying samples you receive an error message like the one below, referencing the “datetime2” data type:

After entering the date and time on the Results Entry By Sample screen, it gives the error “Date and time entered is earlier than the sample’s collected date and time”:

This error suggests the user does not have full privileges on the folder where their LIMS 5 database resides. LimsCode5.mde is the LIMS front end file and Access must be able to update the file. Check the user folder permissions.

This error could be data related. Try exporting a smaller subset of samples to the template. If that doesn’t help you narrow it down or is just not a practical option, then the solution is to execute the template’s macro statements one a...

Verify or try the following steps to allow other workstations to connect to a SQL Server instance. Use SQL Server Management Studio (SSMS) to test the connection between a workstation and SQL Server after each step below until the connec...

SOLUTION: It is possible you are experiencing index fragmentation in the SQL Server database. It is worth trying a

In an LIMS multi-user installation, the View Current Users option on the Admin menu will display a list of all users currently logged on to the LIMS. Viewing a list of current LIMS users can be particularly useful when you need to perfor...

Q: I have a customer who wants to see the product description in the subject line for the results messages. Is this possible and if so, how?

Have you seen either of these warnings? A version of these messages originated with LIMS 2.0 in 1999, when personal computers had far less random access memory (RAM) than today’s typical workstation. However, these messages still serve a...

A runtime error may occur in the results entry screens when importing results from Excel. Note that the error may be limited to a specific workstation in a multi-user installation and will only occur with LIMS version 3.3...

ISSUE: When you click on START in LIMS Messaging, the application closes without starting.

Issue: Users can successfully log in to LIMS, but when you check the Admin> Users screen you cannot see a user and their role.

To pin your J Street LIMS program to your taskbar, follow the instructions below:

We often receive support calls or emails listing one of the following or similar error messages when LIMS is started.

Issue: The template had been working fine and rebooting the workstation had no effect. Exporting the same Sample Summary report to other templates including the generic LIMS Export Template also produced the same error message, which sug...

When you try to start either LIMS 2.x or Access 97, you may receive the following error message:

During system startup the error message “Unable to attach LIMSDATA.MDB or its location may have changed” is displayed if either the location of LIMSDATA has been changed or the file is corrupt. This article describes how to correct the e...

The “Import” checkbox on the Excel Data Import form is read-only. You cannot uncheck it.

When receiving this error message when creating a new import or export template, there are a few things that you will want to verify:

This error points to an issue with the Microsoft Access installation on the workstation, and until this is resolved, LIMS will not function properly.

This error can occur when you are attempting to delete a sample and have a very long reason entered as to why you are deleting that sample.

This occurs when data entered into a field is in the incorrect format. Reduce the selection of records to isolate which record has the error, and correct the data.

This error suggests the user does not have full privileges on the folder where their LimsX.mde resides. Check the user folder permissions and verify that the user has full permissions.