Unanswered: Data Transfer Problem in Foxpro ERP Application
We have an ERP application running on Foxpro database. There are 2 buildings where our users are situated. They are separated by less then 1 kilometer. They are connected by VPN - 3 Mbps connection. The server is located in one of the buildings and all people access the application through this server. There is an icon of the application on each desktop. The users click on the Icon and it links to the EXE and the database both of which are situated on the server. The problem is when we open a screen to make a Goods REceipt Note etc and click on a drop down menu which is populated with Item Master/ Vendor Master etc it takes us more then 3 minutes to load everything on the screen. All workstations have PIV 256MB Ram. Any solutions for increasing the speed?