Running a FoxPro based Database via a router to router VPN connection across 2 domains
Posted on 2006-11-06
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!!