5 ms·
I used to build Access applications and never had data corruption issues while supporting 20 concurrent users. The key is separating the database and front end
by mobjack 7y ago
I used to build Access applications and never had data corruption issues while supporting 20 concurrent users.
The key is separating the database and front end in different files.
While I have many gripes with Access, it is a highly underrated tool.
Using a real database engine requires infrastructure and lots of red tape to set up and it might not even be approved after waiting for months.
With Access, you just put a file in a shared directory and you are done. No need to set up a web server for a front end either.