How do I change the way conflict winners are picked in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a master database at one location & mobile laptops with the database
that we enter information into. The updated databases are them emailed to
the master database to synchronize. Conflicts come up but Access always
picks the older record as the winner instead of the newer updated record.
How do I change it to pick the newer record not the older one?
 
I have a master database at one location & mobile laptops with the
database that we enter information into. The updated databases
are them emailed to the master database to synchronize.
Click to expand...

You can't do this. It breaks Jet Replication completely.
Conflicts come up but Access always
picks the older record as the winner instead of the newer updated
record. How do I change it to pick the newer record not the older
one?
Click to expand...

Well, first off, you've got major issues from emailing files and
synchronizing them. Stop that first (i.e., synch your replicas in
place) and maybe your conflict problems will go away.

If you still don't get your conflicts resolved the way you want,
then you may have not set the replica priorities correctly. Your DM
has priority 100. Any replica made from it will have 90% of its
priprity, so all replicas made directly from the DM will have 90.
Replicas made from a replica with priority 90 will have priority 81
and so forth.

You can change the replica priority with:

CurrentDB.Properties("ReplicaPriority")

For star topology replica sets (central hub replica with multiple
equivalent replicas synching with it), I set the hub to a *lower*
priority, say 81, and all the replicas at the points of the star to
90. This means that all replicas are equal and the winning record
will be determined by something other than replica priority.
 
Back
Top