Paul,
With all due respect, I think you are missing something. I am not suggesting purchasing other computers just for remote login. I guess the concept I need to get across is while it may be optimal to all log in to the "Main computer," since it would be faster, why not have everyone log into client computers and then access the database on the main computer from there. I think you are misunderstanding me about the computers because I keep using the analogy of what happens at work.
At work, everyone uses a computer and accesses the main computer. No one uses the main computer. Even if they did, you certainly don't have more than one person on that computer.
So, it's the same concept. Just as you can't have three people using the main computer at work, you also can't have three people accessing the main computer remotely (as you have stated). So, why not have the remote users access the same computers they would normally access.
Example: I do not have AC program on my server. I do not tend to do ANYTHING on my server. I do not remote into my server. I could, but I don't. And, likewise, I don't run AC on the server when I am physically at work. But, I DO remotely connect to MY desktop at work and use AC just as if I were there.
I wouldn't look at it like it would be faster if you remotely connected to the main computer than a client. Sure, it would. But, you don't think like that when you are at work. You don't tell your employees, "hey let's all line up and take turns to use the server." Sure, each user would be able to work faster, but they would have to wait for each other as you outlined earlier in your example. So, they each use their own computer and access the database, which is what networking is all about.
So, just for fun and CCHITs and giggles, go to three separate computers and install LogMeIn free edition on each. Name one biller, one office manager and one doctor. Then let all of you log in anytime you wish. If it works, great.
Hope this helps.
Bert
