Hi all,
I am looking at a problem we encountered with replication. Our front-end and
back-end are Microsoft Access 2000. We have a design master at the server
and replicas at five notebooks. The notebooks are synchronized daily by the
users via a form that uses Microsoft Jet and Replication Objects (JRO) and
this works well.
I have a few questions about this:
1. A problem occurs when two users change the same field in the same record
at the same time. When they synchronize their replicas, only one 'version'
of the field remains. The other one disappears.
I would say that this is a synchronization conflict, but it does not appear
as such. Also when I open a replica or the design master directly no
conflict is being reported. How can I see which 'version' of the field has
been deleted?
2. If we would be using SQL Server at the server and MSDE or SQL Server at
the notebooks, will the replication work the same way in that the entire
field is being replaced?
3. Is there any replication possibility that merges field changes? (This
maybe a longshot).
Thanks for your attention,
HJ 2 3839
"HJ" <hj********@spamhotmail.com> wrote in
news:41*********************@dreader9.news.xs4all. nl: I am looking at a problem we encountered with replication. Our front-end and back-end are Microsoft Access 2000. We have a design master at the server and replicas at five notebooks. . ..
Are you having users edit data in the design master? If so, that's a
bad idea -- actively used MDBs can be corrupted, and if you lose the
design master you'll have problems.
Create a replica for the central office users to use, as well, and
synch it only occasionally with the design master (which doesn't
need to have up-to-date data). The design master should be
squirrelled away somewhere safe.
. . . The notebooks are synchronized daily by the users via a form that uses Microsoft Jet and Replication Objects (JRO) and this works well.
I have a few questions about this: 1. A problem occurs when two users change the same field in the same record at the same time. When they synchronize their replicas, only one 'version' of the field remains. The other one disappears. I would say that this is a synchronization conflict, but it does not appear as such. Also when I open a replica or the design master directly no conflict is being reported. How can I see which 'version' of the field has been deleted?
The conflict resolution formula is complex, and I don't know if
changes to data in a design master are given priority over changes
in a replica, but it could be that this is the source of your
problem. That is, your incorrect topology may be causing your
problem.
In any event, Jet 4 replication is field-based, but it's still based
on the side with the most changes. That is, if a field in Replica A
has 2 changes and the corresponding replica in Replica B has 1,
Replica A will win the conflict without being reported as a conflict
(all other things being equal). Conflicts are reported only when the
number of changes on both sides are equal.
2. If we would be using SQL Server at the server and MSDE or SQL Server at the notebooks, will the replication work the same way in that the entire field is being replaced?
I don't know for certain, but I suspect that SQL Server replication
won't be any better in this regard. But I haven't used it, so can't
say. There was a time when Jet replication had more features that
SQL Server's.
3. Is there any replication possibility that merges field changes? (This maybe a longshot).
Applications in which single records are being updated in multiple
locations are not good candidates for replication in the first
place. Replication works best when the records edited in different
replicas do not overlap, or are mostly adds/deletes.
It may be that you could restructure your data to use transactional
editing. For instance, if the field that is conflicting is something
like a LAST DATE field, you could move that field into a table where
you record all the dates in order, which won't conflict, because
changes to the LAST DATE are made by adding a new record, not by
editing a field.
That's not the best example, but you get the idea -- with
replication you sometimes have to restructure your data for the
synchronization to work.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Thank you for responding. So for the replication topology I should store the
design master somewhere on the server, create a central (office) replica
that is used and edited by the office users and create notebook replicas
that are being synchronized with the central (office) replica. Then the
database administrator needs to occasionally synchronize the central
(office) replica with the design master.
And for the simultaneous editing of the same field, I will look at the
transactional editing. It may be convenient to store multiple versions of a
certain remarks field in a separate table. Thanks for the tip.
HJ
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@24.168.1 28.74... "HJ" <hj********@spamhotmail.com> wrote in news:41*********************@dreader9.news.xs4all. nl:
I am looking at a problem we encountered with replication. Our front-end and back-end are Microsoft Access 2000. We have a design master at the server and replicas at five notebooks. . ..
Are you having users edit data in the design master? If so, that's a bad idea -- actively used MDBs can be corrupted, and if you lose the design master you'll have problems.
Create a replica for the central office users to use, as well, and synch it only occasionally with the design master (which doesn't need to have up-to-date data). The design master should be squirrelled away somewhere safe.
. . . The notebooks are synchronized daily by the users via a form that uses Microsoft Jet and Replication Objects (JRO) and this works well.
I have a few questions about this: 1. A problem occurs when two users change the same field in the same record at the same time. When they synchronize their replicas, only one 'version' of the field remains. The other one disappears. I would say that this is a synchronization conflict, but it does not appear as such. Also when I open a replica or the design master directly no conflict is being reported. How can I see which 'version' of the field has been deleted?
The conflict resolution formula is complex, and I don't know if changes to data in a design master are given priority over changes in a replica, but it could be that this is the source of your problem. That is, your incorrect topology may be causing your problem.
In any event, Jet 4 replication is field-based, but it's still based on the side with the most changes. That is, if a field in Replica A has 2 changes and the corresponding replica in Replica B has 1, Replica A will win the conflict without being reported as a conflict (all other things being equal). Conflicts are reported only when the number of changes on both sides are equal.
2. If we would be using SQL Server at the server and MSDE or SQL Server at the notebooks, will the replication work the same way in that the entire field is being replaced?
I don't know for certain, but I suspect that SQL Server replication won't be any better in this regard. But I haven't used it, so can't say. There was a time when Jet replication had more features that SQL Server's.
3. Is there any replication possibility that merges field changes? (This maybe a longshot).
Applications in which single records are being updated in multiple locations are not good candidates for replication in the first place. Replication works best when the records edited in different replicas do not overlap, or are mostly adds/deletes.
It may be that you could restructure your data to use transactional editing. For instance, if the field that is conflicting is something like a LAST DATE field, you could move that field into a table where you record all the dates in order, which won't conflict, because changes to the LAST DATE are made by adding a new record, not by editing a field.
That's not the best example, but you get the idea -- with replication you sometimes have to restructure your data for the synchronization to work.
-- David W. Fenton http://www.bway.net/~dfenton dfenton at bway dot net http://www.bway.net/~dfassoc This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Cherrish Vaidiyan |
last post by:
Hello,
I have certain doubts regarding replication of Oracle 9i in Red Hat
Linux 9.
1) I want to implement asynchronous/synchronous multimaster
replication.I have heard about Replication...
|
by: Cherrish Vaidiyan |
last post by:
Frank <fbortel@nescape.net> wrote in message news:<bqgb99$a04$1@news1.tilbu1.nb.home.nl>...
> Cherrish Vaidiyan wrote:
> > Hello,
> >
> > I have certain doubts regarding replication of Oracle 9i ...
|
by: steve |
last post by:
Hi,
several years ago , I implemented the oracle replication system.
At that time our database was ported from an old Fox pro application. ( K ,
no laughing at the back).
As the foxpro...
|
by: Craig HB |
last post by:
I have a distributed inventory control database that I am going to
migrate from Access to SQL Server. I am going to use SQL Server
Replication to keep the data current.
There will one SQL Server...
|
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...
|
by: dlesandrini |
last post by:
I need advice about my decision to go with Replication in general.
This post was placed on the Microsoft Replication newsgroup, but
I really value the feedback that comes from this group as well.
...
|
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...
|
by: David W. Fenton |
last post by:
See:
Updated version of the Microsoft Jet 4.0 Service Pack 8
replication
files is available in the Download Center
http://support.microsoft.com/?scid=kb;en-us;321076
This includes the Jet 4...
|
by: Gert van der Kooij |
last post by:
Hi,
Our SQL Replication is between DB2 databases on Windows servers.
I'm searching for the document which tells me how to migrate our SQL
Replication environment from V8 to V9 (we also need to...
|
by: Query Builder |
last post by:
Hi,
I have transactional replication set up on on of our MS SQL 2000 (SP4)
Std Edition database server
Because of an unfortunate scenario, I had to restore one of the
publication databases. I...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
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)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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...
|
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...
| |