Discussion Locked

Server Question

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I just started using peer to peer in my office. I have 3 computers. We want to share a database between the three. Right now, we can only access the database (ACT) one at a time. If my secretary is using it, I can't and so on and so on. So, I have asked around for solutions and everyone says to get a server. Is this the solution? If so, may I just buy a not so state of the art p.c. and use that as the server and then be able to access and manipulate the database? I am talking multiple user, simultaneous access. If I get a server, what all kind of equipment would I need?
I humbly thank any response to this question.

5 replies

by jimbb

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

by bohicam1

There should be a tool or utility that comes with your software that will allow you each to copy the database over into your individual computers. When you have your software open, look at the menu bar across the very top of the screen. If one is called tools, click on it and check for something like "import/export" if it is not there, try one of the other menu items. You should be able to import the database for each user. Have you looked in the manual? Have you tried to contact your vendor? You may also email me with the type of software you are using and I can search for you.
Good luck!

Mike

This discussion is closed to new replies.