Why can’t we run standalone on a server or store the data file for standalone on a separate computer?
Server software is much more robust than standalone software. There are protections built into the underlying engine that allow simultaneous access to the data file, ensuring that all data changes are written correctly. More importantly, the server software gracefully responds to disconnections from the client. This ensures that if a workstation temporarily loses its connection to the server, the data file remains open and is saved without corruption when the server software properly shuts down.
When running the standalone software over a network, a temporary loss of that connection will close the software without properly saving data. This can result in corruption of the data file.