Solved

Time limit for synchronisation?

Posted on 2002-03-19
6
317 Views
Last Modified: 2012-06-22
My replicated database cannot be synchronisaed - error 3521 is generated.
Two members of the replica set cannot be synchronized because there is no common point to start the synchronization.
Access says that this is because too much time has elapsed between synchronisations.

Is there any way of overcoming this problem?
0
Comment
Question by:vivn
  • 3
  • 2
6 Comments
 
LVL 57
ID: 6879837
What version of Access are we talking about and how old are the replicas?

Jim.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 100 total points
ID: 6879849
Just to get things started, here is a MSKB article link on one possible cause of the problem you describe:

ACC97: No Common Point to Synchronize Replicas After Year 2000 (Q191916)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q191916

Jim.
0
 
LVL 54

Expert Comment

by:nico5038
ID: 6879885
Wooow, a real Year 2000 problem if we may believe M$ and who doesn't....
Using the SP doesn't solve this particular problem, so all that "rests" is to create a new replica and "manually" (or by using queries) append the entries to synchronize again after the SP has been implemented... ;-(

Nic;o)
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:vivn
ID: 6880247
This is an Access 97 database - I'm not sure when it was last syncronised but I think it was 3-4 weeks ago.

I thought that I may have to manually resynch using queries but hoped there may be another way round.
0
 
LVL 57
ID: 6880289
Is this the only MDB that won't sync or is it all on that machine or don't you know for sure?

Also, was this indirect or direct?

Jim.
0
 

Author Comment

by:vivn
ID: 6882188
Jim

I think you hit the nail on the head with the MSKB article.

Of the four replicas only 2 are giving this error message.
We think the 2 causing the problem were created before 2000 whereas the other 2 were definately created after 2000.
The problem seems to have arisen after the design master was compacted (as described in the MSKB article).

Viv

 
 
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question