ms-access has a facility to split its jet2 database into frontend and backend.
The backend stores the data in a file on a shared network drive.
The frontend stores the queries/forms in a file on the client user machine.
Using this 'split' technique, multiple users approx 200 can use concurrently use the database without any problems.
In essence, ms-access is allowing a serverless multi-user database for 200 users on a network shared drive without any problems.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other-mso_o365b/ms-access-multiple-users-working-in-one-database/68a1d292-5b19-421f-b730-17b98be50103My queries are:
1. As lazarus can also connect to a jet2 database, is this split functionality available using lazarus for multi-user serverless read/write usage?
2. If ms-access can manage to use a serverless file on a network share for 200 users to read/write concurrently, why can't other serverless systems such as sqlite/firebird do something similar?
3. Does anyone understand the logic of how it manages 200 users to read/write a single database file on a network share without problems?
Thanks