OK, I guess I will continue to try. I don't understand your company. Going to two databases is a huge step backwards. This really isn't that difficult.

Here is where I see the problem. From what you have stated, you have a total of 50 computers in two offices with the remote office running computers with AC on them and then trying to connect to the server over the Internet using a VPN. As Sandeep says, if a lot of data is going back and forth, it will be slow compared to using RDP.

I have eight computers and still find myself spending quite a bit of time maintaining the network. A 50 computer network for a doctor's office is definitely a SMB network. I would suggest getting rid of these "IT teams" such as the A-Team or any other one and hire one good half-time Microsoft-Certified Information Technology Professional. Doctors generally want to do things on the cheap, and it ends up costing them in the end. My network specialist always wonders why so many computer users, especially doctors, try to build and maintain their own network. Get one good IT person that will maintain your network and be available when you need them. A good MCITP or Network MVP probably would have had a TS set up by now. Likely your backups would be better. Your network would be more secure. I could go on and on.


Bert
Pediatrics
Brewer, Maine