un***************@yahoo.com (Cherrish Vaidiyan) wrote in
<f0**************************@posting.google.com >:
I am working on Oracle 9i on Linux. I have a simple clarifications
to be made..
Is there a concept of replication in MS ACCESS ?
If yes, Any GUI Tool available for it ?
The only valid reason for using Jet replication these days, I
believe, is for laptops.
Jet Replication does not work well for any part of an Access
project except the data tables and queries (Jet objects).
Replicating forms and reports eventually leads to corruption and
data loss.
If you're trying to support remote users of an existing Access
application, I would say that Windows Terminal Server is a much
better option than attempting replication, which is fraught with
problems.
For what it's worth, I started using replication with clients'
applications back in 1997 and at this point, have no clients still
using it. On the other hand, one client operated an office in
London and an office in NYC, along with two outside contractors at
home in Connecticutt, using replication, and they did this for
nearly 3 years. It worked very well, but it was fragile and needed
lots of care to keep it all working smoothly.
Now I'd do the same thing with Windows Terminal Server, hosted in
the NYC office.
--
David W. Fenton
http://www.bway.net/~dfenton
dfenton at bway dot net
http://www.bway.net/~dfassoc