Kelvin
A bit difficult to give you a straight answwer but here are som things I would look for
1. How many pcs on the LAN? Is the server the master browser? (come back to this in a moment) When was the network last restarted?
The first machine in the network to be started and logged in becomes the master browser - this MUST be the server - but if pcs are started randomly it is quite possible that one of the slowest pcs on the network becomes the master browser and then the network runs very slowly
If your LAN has not been restarted for a while try that - thats why I asked you how many pc's to see how big a job that would be
When was you server last defragmented? Very importantly when was it last boot time defragmented (you need Executive Sofware's Diskeeper for this - but be warned it can take upto 12 hours to run - it defragments the paging files amongst other things - makes a major difference to the speed of a machine) - see if you can assess the speed of the server itself - this may be causing the problem
2. Check that you don't have problems with antivirus software - try running a workstation with the antivirus software turned off - some editions of Norton in the past have brought networks to a standstill
3. Your VFP executable and tmp files should be on the workstations and the data on the server
Hope that helps
Colin
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing