By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,064 Members | 1,542 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,064 IT Pros & Developers. It's quick & easy.

Synchronisation nightmare

P: n/a
I have a client running Access 2000 on a desktop (win 98) acting as
the 'server' and a Sony Viaio notebook (win 2000). They are
synchronising and
the data on the laptop is continually getting corrupted. The symptoms
are either relatively minor but very irritating 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, more
seriously and 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 servier to W2000 or xp but client not keen as they
will probably need to upgrade the PC

It is driving both me and my client crazy - any suggestions very
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.