Multi-user file with Excel/VBA front-end, *sql* back-end?

[Ramachandran]

In my current system I have one Excel file where the user interacts through forms and data are written to a hidden sheet mimicking a database.
Conversely whenever a sheet is opened it is populated with data from the hidden sheets. All cells are locked for editing, every user input is through a form with the proper constraints, the input is processed through VBA and then written/read.
The "database" contains one sheet with all employees and employee data with an unique identifier,
and a few other sheets linking the employeeID with work schedules, etc.

The Macro-enabled Excel file is located on a server, and a few people use it every day - one at a time.
Naturally it would be better if several people could open the file at the same time - while keeping data integrity.

Any tips on how to go about?
SQLite, MySQL, Access, write-to-and-read-from-csv,...?
Further reading?

 

[ranman256]

use microsoft Access, its what it was built for.

 

[Ramachandran]

Another question:
The excel file (xlsm) is located on a server.
Any strategies on how to be able to let several users use "the file" at the same time?
That is, to use the forms to write to the DB and open its sheets that reads from the DB?

Open the file, duplicate it (filename_username.xlsm), close the main file, delete filename_username.xlsm when close?

 

[Kyle123]

You don't need an xlsm if you use Access, if you do still want to use it then everyone may open the same spreadsheet as read-only