Susan Harkins
ssharkins at setel.com
Thu May 10 09:30:27 CDT 2007
John, If possible, use disconnected recordsets to retrieve data from the network, work with locally, and then submit back to the network for batch updates. If data entry doesn't need to be live, that's a good solution, unless of course, you've got several data entry operators working on the same records -- that can spell trouble with the batch updates. If that's the case, you need to consider replication, which is a completely different critter. Susan H. My boss seems to think it is fine. He said, at his former company they ran an Access app between Niagara Falls and Dallas, and it was slow but doable. He said an operation that ran in 2 sec., would now take about 20 sec.. This is fine for someone like me, to do something once in a while, but a data entry person will go nuts w/these times. So, basically I am looking for some definitive information regarding this, so that I can make a better decision about going ahead w/this.