G
Guest
I have a client running Access 2000 on a desktop (win 98) acting as the
'server' holding the design master, and a Sony Viaio notebook (win 2000)
with a replica. They are synchronising and
the data on the laptop is continually getting corrupted. The symptoms are
either relatively minor but irritating things such as a) not finding records
based on the primary key, so all records being
displayed or b) queries showing duplicate records (doubled up) for no reason
whatsoever, when all the joins are on unique indexes or, worst of all, all
new records entered since the last synchronisation suddenly disappearing from
both sets of data after synchronisation. When this happens, the records are
usually to be found in the 'conflicts' tables, although there can't be any
conflicts. After synchronising, the user is told there are conflicts to
resolve but when opening the conflict resolution tool no table conflicts are
shown.
Is it possible that the Office installation could be at fault? They have a
mixture of OEM versions, and not SP3. Or could it be because the laptop
replication library file references are via the network on the Win 98
machine, due to the fact that the library files are on different locations on
the two machines. I think the only way to resolve that is to upgrade the
server to W2000 or xp, client not keen.
It is driving both me and my client crazy - any suggestions very welcome
indeed!
'server' holding the design master, and a Sony Viaio notebook (win 2000)
with a replica. They are synchronising and
the data on the laptop is continually getting corrupted. The symptoms are
either relatively minor but irritating things such as a) not finding records
based on the primary key, so all records being
displayed or b) queries showing duplicate records (doubled up) for no reason
whatsoever, when all the joins are on unique indexes or, worst of all, all
new records entered since the last synchronisation suddenly disappearing from
both sets of data after synchronisation. When this happens, the records are
usually to be found in the 'conflicts' tables, although there can't be any
conflicts. After synchronising, the user is told there are conflicts to
resolve but when opening the conflict resolution tool no table conflicts are
shown.
Is it possible that the Office installation could be at fault? They have a
mixture of OEM versions, and not SP3. Or could it be because the laptop
replication library file references are via the network on the Win 98
machine, due to the fact that the library files are on different locations on
the two machines. I think the only way to resolve that is to upgrade the
server to W2000 or xp, client not keen.
It is driving both me and my client crazy - any suggestions very welcome
indeed!