Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Running a FoxPro based Database via a router to router VPN connection across 2 domains

Posted on 2006-11-06
Medium Priority
Last Modified: 2010-04-12
First off, let me start off by stating, I am by no means an expert with networks, but have been asked over the past 4 years to care for our 2 separate networks (at 2 locations). My primary job is Graphics and Customer Service. With that said, recently we decided that the 2 locations should talk via a VPN connection so that we can access the files from both locations. This has been a very long process (3 months) and finally the VPN is up and we have just in the past couple of days been able to establish trust between the 2 domains.

The next step is....we want to be able to run the Accounting Software, which is a FoxPro Based Database. To make this easy to follow, let's say our two locations are LA and Sacramento. The files for the Accounting software are located in LA and we at Sacramento want to be able to run them. I am being told by the people who made the Database, that we have to run it off a mapped drive. In Sacramento, I have mapped the drive to the same location and same drive letter, as we do down in LA. And I have created a shortcut on my desktop to run this software targetting the mapped drive and required files.  We have been successful at getting the program to run but what normally takes 20 secs is now taking 10 mins to even load. And then to run anything else it locks up the system.

Any suggestions would be helpful. Thanks!!
Question by:Deluxepackages
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
  • 3
  • 2
LVL 77

Expert Comment

by:Rob Williams
ID: 17886260
Unfortunately the last thing you want to run over a VPN is an application making use of a database. There is so much "chatting" going on that the performance is terrible, and further more it can result in corrupt data. The best way to deal with this is to connect to a computer in LA (where the data resides) using remote desktop or a similar utility, over the VPN, and run the accounting application in this way. Doing so means only the screen changes are transmitted across your VPN, and performance is usually great. If you are not familiar with remote desktop please advise and we can provide the necessary details.

Author Comment

ID: 17891011
I have actually done something similar to this by using PC Anywhere to get us access, but this is not the solution we want. 1) We have dificulties printing, 2) File export and transport is dificult, but the reason it makes it not a solution is 3) only one person can be on the system at a time. We need to have 3+ people accessing the database at the same time.  Any other suggestions.
LVL 77

Accepted Solution

Rob Williams earned 2000 total points
ID: 17891135
Terminal Server would be the only other option I could suggest. Basically the same solution but allowing multiple simultaneous users. Not a cheap answer though.

If you want to do some tinkering, different articles claim to have it working. Below is a link explaining how to allow a second user to connect to an XP machine using remote desktop. Includes a link to the required Terminal Server file for download. good luck:
Helpful comment by one successful "tinkerer"
It worked perfectly after I worked around one issue...I had to modify the .reg file. Instead of "ControlSet001" I had to change the path to "CurrentControlSet". After that, it worked like a charm! Thanks!

One other option which I have not tried is a third party utility to allow up to 21 users:

Author Comment

ID: 17891270
Thanks RobWill, I will look into these articles, but I will more likely end up going to the Terminal Server. I had already thought that was the path that I might have to take, but was hoping there might be a cheaper path I was over looking. Thanks again.
LVL 77

Expert Comment

by:Rob Williams
ID: 17891315
Thanks Deluxepackages,
The last option from ThinSoft looks interesting. I think you would be limited by the hardware with XP, but 3 users might work fine with a GB or more of RAM, and $300 sounds pretty good. I don't know if they have a demo version though. It would be nice to test first.

Good luck with it.

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Sometimes, you want your microsoft VPN to route all the traffic to the remote network. Usually your employer network. This makes it possible to access all the nodes inside this remote LAN, even if they have no "public DNS" entries. To do so, you wo…
For a while, I have wanted to connect my HTC Incredible to my corporate network to take advantage of the phone's powerful capabilities. I searched online and came up with varied answers from "it won't work" to super complicated statements that I did…
After creating this article (, 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…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Suggested Courses

715 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