Free E-Books

When a synchronization conflict occurs, Jet determines a winner by looking at the version numbers
of the records. You??™ll recall that the s_Generation field is incremented each time there is a
change to the record. Given two conflicting fields with differing s_Generation values, Jet
chooses the record with the most changes (and therefore the highest version number) since the last
synchronization, on the assumption that the data in that record is the most recent.
In the case where both version numbers are the same (for instance, each record has been changed
only once), Jet chooses a winner based on the replica??™s ID number. Admittedly, this is an entirely
arbitrary way to choose a conflict winner, but it does provide for a consistent selection between
conflict pairs.
In any case, Jet records the synchronization conflict in a conflict table (sometimes called a side table)
that is local to the replica that lost the conflict resolution. The conflict table is named
TableName_Conflict, where TableName is the name of the table with the conflicting records.


Pages:
1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881