I desing a data entry program when we used data file through network(LAN) then the connection become very slow .File opens after a large interwal .The dbf having more than 10,0000 data and im sharing this file between the three operators. Can i use dsn for this problem ? pl. suggest
Sounds more like a network related problem since these type of databases are file based and since theres no server doing the processing all the data needs to be transfered back and forth which results in a need for a healthy network. Are you able to diagnose the 3 clients connectivity/speed to the location where the files resides?