I guess if the server had Hyper-V and two VMs, you could look at the workstations three ways. I am not sure if they would all work. If you were able to connect to the specific database using the virtual switch, the information would be changed in AC to the database. Two different accounts would seem best, but I suppose you could use the same one. I wouldn't.
You could reset the path to AC, then browse to the correct database.
You could use a VM.
Of the three, a VM would be safest as it could be set via the virtual switch to go to the correct database.
I think that would be the biggest issue. Connecting to the same database by mistake. Of course, the names would be different, etc., but there could always be that chance.
Which leaves the two safest options:
A VM on one account. The accounts would need the username and difficult password, so when a user logged on, they would have to be logged on to the correct AC.
Actually, you couldn't use just two accounts as the path wouldn't be dependent on the account but on AC as you would both access the server.
I suppose the second account could use a second NIC card which ran to the second database on the server.
My best advice would be to PM Sandeep on the Top Posters list on the right and ask him to look at your question. He probably knows 50 times more about this than I. He'll give you the best answer and tell you where I am wrong.
I still don't see how your doctors would not overlap.
You could send a blank message to John's Medical Practice and make the color red so it always stated at the top right. In the other medical practice do the same but make it green. Why both? Because someone may delete the other temporarily.
