473,662 Members | 2,596 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Synchronisation nightmare

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
welcome!
Nov 13 '05 #1
0 1125

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2299
by: Drisco | last post by:
Hello, I realy need help,Searched the NG for a days with no vail. Sorry for the long script. I am trying to get a variable from php to flash. I have the following code in php <a href="artist_page.php?12345678=<?php echo $row_rs_Q_Gender_to_Artist; ?>"><?php echo $row_rs_Q_Gender_to_Artist; ?></a>
3
1556
by: wesley | last post by:
Hi List, I have a question on collection synchronisation. For example I have an ArrayList called myList and the code is like this: lock (myList.SyncRoot) { // do update on myList Monitor.PulseAll(myList.SyncRoot); }
10
1856
by: Dumbo Liz | last post by:
Hi I hold a Design Master for development and synchronise this weekly with my colleague who enters data and runs reports. This has worked well for the last 3 months. (He e-mails me a copy and I'm scrupulous about keeping files in the right place!) This week Synchronisation failed because "it is not a replicable database". I tried compact and repair on the Replica. This produced Conflict Tables for both my Tables and...
0
1437
by: Tony Epton | last post by:
I am not quite a newbie in the area of SQL server - more "knows just enough to be dangerous" - so please be gentle with me. Cross posted to several groups - apologies if too far off topic I have an application that does a lot of massaging of data (insurance claims) from 3 different data sources to present one set of nice homogeneous output tables. Uses about 200 various tables and about 300 queries to do the work ( sounds like a mess -...
9
1488
by: Dave G | last post by:
The unexpected problem is this - say, 2 pcs called A and B, both running my Access program, both arranged in a FE/BE arrangement. There is an unbound form in the program. When the form opens all the fields are populated with the required data from the required record. When the form is closed every field is saved back to the relevant record, whether it changed or not. I now realise this is wrong - eg on machine A a name field changes from...
0
1032
by: tbb | last post by:
Hi is it possible to do the synchronisation of the briefcase programmatically? Greets tim
1
1669
by: chengsi | last post by:
Hello, I am trying to create a button which users can click to activate the synchronisation process within a replica set without having to use the MS Access menus or the Database window (as both of these will be disabled). Any ideas would be much appreciated. cheers, Siwei
19
2298
by: Hapa | last post by:
Does only reading (never writing) of a variable need thread synchronisation? Thanks for help? PS. Anybody knows a Visual C++ news group?
4
3076
by: sujatha k | last post by:
I want to create one window service to synchronice my local database with server database.i've done the synchronization process in .net application it is working fine. i copied tat code and put it in windows service OnStart() method. but it is not working. i'm very new to window services. please help me out in this.
0
8435
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8345
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8768
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8547
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8633
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7368
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6186
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4181
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
1999
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.