A server is just a big shared file-storage. In other words, nothing more than you have now, except that it is dedicated to just doing that. In other words (again), if your database or your application doesn't allow simultaneous usage now, it won'tdo so on a server either. What you need is a multi-user version.
The difference is the way the database program protects itself against corruption. The easiest way is to "lock" the entire file, so nobody else can do things in it at the same time. A more advanced way is to lock individual records, to allow that user A for example changes the phone number for client X, while user B changes the email-address for client Y, at the same time. This is the main difference between a "single user" and a "multi-user" database.
And as for a server, basically it is just a PC. The difference has to do with all sorts of manageability and fault-tolerance features. For example, you'll want a RAID, which is a set of disks that "work together", to allow for one disk to fail without data loss. But if you just want a central file-storage for your PC's, a "standard" PC will function as well - without the fault-tolerance of a "server" of course - and will be a lot cheaper. Don't forget some kindof a backup as well. If 1 PC crashes, 33% of your data is gone. If your server goes to the PC-Walhalla, 100% of your precious information is residing there too...
Jim