473,320 Members | 2,006 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Do MS ACCESS have the concept of Replication ?

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
2 2051
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Cherrish Vaidiyan | last post by:
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...
2
by: Beda Christoph Hammerschmidt | last post by:
MySQL, Access, ODBC, Replication Hello, i have a central mysql database that is accesed by multiple clients running MS Access with ODBC. This works fine if Access has a permanent connection...
6
by: John | last post by:
Hi We have an access app (front-end+backend) running on the company network. I am trying to setup replication for laptop users who go into field and need the data synched between their laptops...
56
by: Raphi | last post by:
Hi, I've been using an Access application I wrote for an office with the front-end stored on all computers and the back-end on one of them serving as an Access file server. Now we're moving...
8
by: Rick | last post by:
I'm running an Access2000 front end mde linked to an Access2000 back end mdb. I need to set up replication and synchronization of only the data tables between the master db on the pc and replicas...
4
by: John | last post by:
Hi Is there a way to synchronise/replicate an access db with sql server 2000 db, short of writing the code oneself? Thanks Regards
18
by: Asif | last post by:
Hi all, I am working on portal which is using MS Access 2003 database. The problem that I am facing is that once I received data from vendors I have to upload whole Access Database file to...
0
by: varathasiva | last post by:
Dear All, I am using postgres sql 8.1 version.That version have a replication conecept. Hw to use the replication concept in postgres sql.I need to replicate one database server to another...
0
by: ParasakthiGuru | last post by:
hai, i don't know Replication concept if anybody can know that replication concept pls sent to me replication brief tutorials By Guru
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.