By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 892 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

Do MS ACCESS have the concept of Replication ?

P: n/a
sir,

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 ?

Thanking in advance ...

regards,
Cherrish
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You can replicate an MS Access database ... it's not for the faint of heart
and isn't a trivial matter, however. There are several good resources for
replication (microsoft.public.access.replication is a good newsgroup to
frequent; the Access Developer's Handbook go into replication in some
detail.

If your frontend built in MS Access, hitting an Oracle database? I assume
you could replicate the frontend, but FWIU, replication is intended to
replicate data, not design.
--
Scott McDaniel
CS Computer Software
www.thedatabaseplace.net

"Cherrish Vaidiyan" <un***************@yahoo.com> wrote in message
news:f0**************************@posting.google.c om...
sir,

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 ?

Thanking in advance ...

regards,
Cherrish

Nov 12 '05 #2

P: n/a
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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.