SQLite not suitable for simultaneous multi-user access

During import of experimental data, the error message “SQLite error 'database is locked' (error code 5).” appears.

The error will be generated when the *.sqlite file is shared by multiple BioNumerics databases, which is not a recommended setup. When data is written to the SQLite database, the *.sqlite file is locked for the duration of the action. If a second user tries to save information at the same time, the mentioned error message will appear and data import will fail.

For file-based database systems such as SQLite and MS Access, we do not recommend a setup that allows simultaneous multi-user access. Relational database servers such as MS SQL Server, Oracle or MySQL are much better suited to handle concurrency issues.


Applicable for: 
Version 7.5 - 8.0