Is the database structure good?

Question

SQL

Tell me, please, is the structure of working with the database good?
There are two programs written in C #, they mainly work with the database.
The first program runs on one computer, the second on another.
On the third computer there is a file with a database, which is shared on the local network.
The programs have a path to the database.
Will it be right? Or is there a better way to work?

Answer 1

No, this is a very bad database structure.
1. If both computers with programs are in LAN, why allocate a third computer to store the file? Keep it on one of the computers with the program.
2. In general, in fact, the database file should not lie somewhere, and programs should not access this file.
If two programs work directly on the same file, they can interfere with each other.
That's right - there must be somewhere (on any suitable computer) that the base server is running, to which your programs connect. And this database server already manages exactly how the data is stored so that two programs, working with this data, do not interfere with each other.