| Navigation: SQL Drivers > SQLite Accelerator >SQLite multi-user |    |
Updating data with SQLite
You can access the same SQLite file from multiple processes. However, only one process can write to the file at the same time. Once a process has written to any table in the SQLite database file that process is the only process that can write to any table in that database.
SQLite and Multithreading
SQLite is designed to be used on a single thread but he Clarion file driver overcomes this limitation as much as possible. To make this work the driver has one limitation on usage. Only one thread can be accessing the SQLite database while a transaction is active. If another thread attempts to access an SQLite database and another thread is in the middle of a transaction, the non-transacting thread will wait until the transaction is completed..