How to work with a DB on a network?

Question

Delphi

The base lies in the shared folder on the server.
The path is something like this \\Server\base\base.mdb
How to make it so that several users can use this database at the same time, so that when the data in the database changes, the database is immediately updated on another client.
I work with ADO components.
Delphi.

Answer 1

Switch from Access to some SQL server.