Solved

VPNs and Syncs

Posted on 2009-04-10
4
456 Views
Last Modified: 2012-05-06
Experts,

I am asking this question, because I always get confused as to just what one can do with a VPN and the types of VPNs one can set up. I am trying to help someone with something they are trying to do, and it is a bit like the blind leading the blind. So here goes.

There are three doctors all working in three group homes intermittently with laptops computers. They are all using the same Electronic Medical Record. Each will have an Access database which, of course, stores all of the patient encounters. Of course, each doctor will want to have the same information.

So, there is a central office with a server which houses the actual database with all of the information of all the patients of the three group homes. So, at the end of the day each doctor will want to sync his or her data to the central server. The person I am trying to help just thinks she can have three VPNs from each group home to the central server and just sync from there. I am not sure what type of Internet connection she plans on using. I can find out, of course.

So, I see some issues and questions about this.

1. Wouldn't each location or each laptop need some type of router with a VPN to connect to the VPN at the server?
2. Wouldn't that have to be at the point where the Internet connection is at the location?
3. Again, I get confused with VPNs at times. When I download the SBS connection manager and set it up and connect, I have a VPN, but I can't see the computer I am connected to.
4. I have a VPN connection from my office to the hospital I work at which uses Cisco's EASY VPN, and I can see the hospital computer information, but I believe they use Citrix. Do you need some type of software so you can actually interface with the desktop or database?
5. I would also think there would be a logistical issue. Say Dr. A syncs at 7PM with the server. Now Dr. A has all the information on the server database (as she did before), and the server database is updated with Dr. A's new information. Then Dr. B syncs at 8PM. He now updates the server and has all of that information plus Dr. A's. But, Dr. A is missing that information. And the same with C. He would have ALL the data, but A and B would be missing his.
6. The EMR is designed to connect to the network via a computer with USB. It then syncs. How easy would it be for a computer to sync to a server's database over a VPN?

I don't know why each user couldn't use RWW, RDP, LogMeIn or VNC to connect to the actual EMR on the server and work on the actual EMR on the server.

Any information would be appreciated.

Thanks.

Bert

Again, in general, I understand the concept of tunneling and using a VPN to connect securely. I guess I just don't know how they can be set up and what they can allow you to do as far as using a remote network.
0
Comment
Question by:Bert2005
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
The--Captain earned 500 total points
ID: 24128591
>I don't know why each user couldn't use RWW, RDP, LogMeIn or VNC to connect
>to the actual EMR on the server and work on the actual EMR on the server.

Neither do I, if you're using a secured connection (like a VPN), although bandwidth issues could be an issue I suppose, which you might be able to avoid by running apps locally but pulling data from the master server.

If you're using MS Access, surely you realize that it can operate simply as a front end, pulling all it's data from your master SQL server, thus obliviating the need for periodic syncs, since all data is constantly updated live (wifi is your friend, since that enables constant network connectivity for roaming doctors).

Does that help any?

Cheers,
-Jon
0
 
LVL 1

Author Comment

by:Bert2005
ID: 24130740
I think it does. I apologize that I am probably ten times more on top of this stuff than the doctors I am trying to help and that still leaves a lot to be desired.

I still get confused as to exactly how VPN works when connecting to remote sites. For instance, I could set up a tunnel using VPN from one computer to a server, but it seems as though I would need something like Citrix to interface with the computer's desktop.

And, I do get confused with Access and SQL at the back end. How would WiFi help unless you mean the remote sites have a wireless broadband access, which is what I think you are referring to.

Syncing is something I think they need to avoid as eventually with three people syncing on and off, there are bound to be errors.

I agree with you that it seems the best way would be to directly connect to the application remotely as long as it is fast enough.
0
 
LVL 16

Expert Comment

by:The--Captain
ID: 24134647
Wifi is for the doctors, so they stay constantly connected to the network and thus avoid having to "sync" periodically.

0
 
LVL 1

Author Comment

by:Bert2005
ID: 24137689
I know this is a given, Captain, but that would mean that all three doctors in all three locales would have to be able to connect to the wireless network that hopefully wouldn't be securely locked down. Then again, I would hope they would allow the doctors on it given they are working on their patients.
0

Featured Post

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question