[AccessD] Access at a distance

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.





More information about the AccessD mailing list