If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I change the way conflict winners are picked in Access?
I'm assuming that you are not using the built-in replication tool. In your
shoes, I'd use replication as it would better automate the synchronization process. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "ELA3355" wrote: 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? |
#2
|
|||
|
|||
How do I change the way conflict winners are picked in Access?
Sorry about my incorrect assumption.
-- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "ELA3355" wrote: Thank you for replying. Yes, I think I am using the built-in replication tool. I go to Tools, Replication, Synchronize Now & it synchronizes the databases. After its successfully synchronized, then it shows the conflicts. However, it seems that Access always picks the older version of the record that was updated as the conflict winner not the most recent which is always what I want. "Jerry Whittle" wrote: I'm assuming that you are not using the built-in replication tool. In your shoes, I'd use replication as it would better automate the synchronization process. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "ELA3355" wrote: 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? |
#3
|
|||
|
|||
How do I change the way conflict winners are picked in Access?
Thank you for replying. Yes, I think I am using the built-in replication
tool. I go to Tools, Replication, Synchronize Now & it synchronizes the databases. After its successfully synchronized, then it shows the conflicts. However, it seems that Access always picks the older version of the record that was updated as the conflict winner not the most recent which is always what I want. "Jerry Whittle" wrote: I'm assuming that you are not using the built-in replication tool. In your shoes, I'd use replication as it would better automate the synchronization process. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "ELA3355" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|