Time limit for synchronisation?

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?
vivnAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
What version of Access are we talking about and how old are the replicas?

Jim.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nico5038Commented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

vivnAuthor Commented:
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
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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
vivnAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.