D
DRCR
I recently adopted a database when moving into a new clinic. It is used to
track our patients' lab results, treatments, etc. Four replicas exist, one of
which we use as the master. However, I am unsure if it is the Design Master
or not, though I doubt it is. I believe that exists somewhere offsite in
possession of the person in our organization who designed the database. At
the end of each clinic day, I synchronize all of the copies because patient
info has been entered in each replica in each of our different offices. Our
computers are not linked by internet, so I do this manually. I transfer
copies of each of the replicas onto our main computer, open our "master"
replica, then synchronize (from Tools>Replication>Synchronize) with each
replica (1 with 2, 1 with 3, 1 with 4, 1 with 2, 1 with 3) so that each
replica should have all of the updated information.
My problem is that the replicas are not synchronizing evenly. Specifically,
the master (and thus all other replicas) seems unable to accept new data from
one of the replicas (let's call it replica 2). However, all of the new data
from the other replicas is transfered to replica 2 during the
synchronization. The reason I first noticed this was taking place was that
the total record tally for replica 2 was increasing faster than the others.
Each time we add a new patient, we add a new record. After further
investigation, records of the new patients first added onto replica 2 were
not present in the other replicas, including the master, after
synchronization. However, new patients added to the other replicas were
present in replica 2 after synchronization.
I have no idea how to rectify this situation, or even where the problem lies.
Also, if anyone has any advice on a simpler method of synchronizing all of
these replicas without internet connection, I'd love some help with that.
track our patients' lab results, treatments, etc. Four replicas exist, one of
which we use as the master. However, I am unsure if it is the Design Master
or not, though I doubt it is. I believe that exists somewhere offsite in
possession of the person in our organization who designed the database. At
the end of each clinic day, I synchronize all of the copies because patient
info has been entered in each replica in each of our different offices. Our
computers are not linked by internet, so I do this manually. I transfer
copies of each of the replicas onto our main computer, open our "master"
replica, then synchronize (from Tools>Replication>Synchronize) with each
replica (1 with 2, 1 with 3, 1 with 4, 1 with 2, 1 with 3) so that each
replica should have all of the updated information.
My problem is that the replicas are not synchronizing evenly. Specifically,
the master (and thus all other replicas) seems unable to accept new data from
one of the replicas (let's call it replica 2). However, all of the new data
from the other replicas is transfered to replica 2 during the
synchronization. The reason I first noticed this was taking place was that
the total record tally for replica 2 was increasing faster than the others.
Each time we add a new patient, we add a new record. After further
investigation, records of the new patients first added onto replica 2 were
not present in the other replicas, including the master, after
synchronization. However, new patients added to the other replicas were
present in replica 2 after synchronization.
I have no idea how to rectify this situation, or even where the problem lies.
Also, if anyone has any advice on a simpler method of synchronizing all of
these replicas without internet connection, I'd love some help with that.