I want to ask a question maybe absurd about a simple issue of network access to a database.

It is about not accessing a database through a server, but to access a database file through the network, through a shared folder.

The problem is that if you access the same database in the same PC, everything works fine and fast. But when I do it from two different PCs, first I have to open it from the PC that accesses the network, and then by the PC that contains it.

Specifically: one PC has the database and another accesses the same database through the network per shared folder.

file locking logic is buggy in many network filesystem implementations (on both Unix and Windows). If file locking does not work correctly, two or more clients might try to modify the same part of the same database at the same time, resulting in corruption.[...]Checklist For Choosing The Right Database Engine1. Is the data separated from the application by a network? → choose client/server