473,789 Members | 2,617 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Replication/Synchronisation failure

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 MSys_Access_Obj ects_Tables. When I tried
to resolve these I was unable to View because "no tables" !!!
From the Replica I do not have the option to make it a Design Master
(the only option available is "Make Replica")
I haven't actually changed the Design Master since this Replica was
made. But I don't want to lose all the data my colleague has keyed in.
And I'm worried about why this has happened.
Can anyone help? I'm off to cook Christmas Eve dinner for the family,
so there's no rush.
Thank you, and a Merry Christmas to all
Liz
Nov 12 '05
10 1869
Hello David
Sorry, I think panic was setting in! Queries succesfully imported,
unreplica fine, database split OK and I'm sighing with relief.
Thank you so much for all your help.
Liz
Nov 12 '05 #11

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

Similar topics

0
2023
by: Cherrish Vaidiyan | last post by:
Sir, I have implemented asynchronous replication on 2 database located in 2 different system. I did it with Replication Management GUI Tool. Before explaining the error i will explain my replication environment. The details of the systems are Hostname1- node2 Hostname2- node3 ip address- 192.168.0.232 id adress- 192.168.0.236 DB name- apple DB name- ibm
7
1786
by: Peter King | last post by:
I am trying to figure out the best way to handle a system with lots of roaming laptops wanting to take the data with them. I have the following requirement: Web server (possibly several) which holds main database and everyone connects to (PHP web site with updates) Lots of laptops (up to 50) take copies of the master data with them to work on locally (Same PHP web site) Laptops now connect back online after making local updates and...
2
1600
by: Ian Wyld | last post by:
Hello All We intend to replicate a database in order to have it as a near immediate standby in case of the failure of the main server. Is this the best solution for disaster recovery? We are currently testing our replication plan. When we set up the subscriber, a snapshot of the publisher is created and this takes hours. Is there a better way?
9
2451
by: Jan Wieck | last post by:
Dear community, for some reason the post I sent yesterday night still did not show up on the mailing lists. I have set up some links on the developers side under http://developer.postgresql.org/~wieck/slony1.html The concept will be the base for some of my work as a Software Engineer here at Afilias USA INC. in the near future. Afilias is like many of you in need of reliable and performant replication solutions for backup and failover...
1
1966
by: karl | last post by:
I am currently investigating MS Access replication, my initial thought is to use 'Indirect synchronisation' due to remote disconnected client base. With this conclusion, I am presuming the 'Replication Manager', which is part of the MOD edition will be required. My only concern is that we will probably purchase a copy of Office 2003 MOD edition, and the Project itself will be developed in Access 2000 due to all clients using 2000....
6
7491
by: John | last post by:
Hi I have a front-end/back-end access app. I have created a replication set between the backend on a server an the backend on a laptop. My question is; How can I cause the synchronisation to happen via code? Basically I need to give the user an option to press a button (or menu option) on the laptop when the laptop is connected to the server/network for synchronisation to happen. Thanks
6
6502
by: Tjeez | last post by:
Hi folks, I'm totally not familiar with DB2 databases, but for a project at work I need to synchronize a MS SQL database with a DB2 database. The MS SQL server is (offcourse) on a Windows 2003 server, while the DB2 database is on a non-windows environment. Now I wonder what is the best way to accomplish synchronisation/replication? Is there a built-in tool to do this, will I need third party software, or will I need to write my own
8
1485
by: Sharktbbtfy | last post by:
Hi, hoping someone can help. The situation is that an app I designed is installed on a desktop PC and six laptops,separately, which synchronise to the desktop once a day at random times. I have two questions: 1) Is it advisable to not have the design master as the mothership but have a replica on the desktop where the backend is named, e.g., replica of
1
1376
by: andersonm82 | last post by:
Rightyho, I am in need to set up an indirectly (offline laptop-usable) synchronising database system without access to run server side processes. It looks to already work, but for testing purposes only on 3 laptops at the present time (ultimate goal - 7 to 20). In the following way; 1. Design Master resides on a network folder 2. A replica of design master (affectionately called 'replica master') resides on a network folder. Replicas are...
0
9666
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
9511
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
10199
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
10139
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
9983
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
5417
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...
0
5551
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3700
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2909
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.