Sharing between users on same machine

Sorry if this has been covered before, but I was curious if there was a “best” solution to sharing a database between multiple users on the same machine? I know that only one user can open/view the database at a time, and that’s a trade-off I’m willing to make.

Is there a difference between saving the file in ~/Shared and ~/Public?