Replication conflicts

message from Dave on 10 May 2004

This question is aimed at users of replicated databases.

We have had recently a lot of Unique Key conflicts.
Where the big keys in the tables (cant remember name)
{1234-4321-1234-4321-1234}
which should have millions , if not billions of combinations is comming up
with duplicates.

i was wondering if anyone has this problem as mush as i have.
about 5 times in 2 years (which doesnt seems alot but surely should be
virtually non-exsistant)
but once it has happened once in a replica set, thats it. it starts
happening lots
Is there something that i am doing to instigate this ?

I usually just synconise all the replicas and the copy all the tables into a
new blank database then
make another replica set out of that. Which will usually fix the situation.
untill the next time .....

any thoughts / ideas?

Dave

Tony Toews replied to Dave on 10 May 2004

If you don't get an answer here I'd suggest asking in the replication
newsgroup.

Tony

David W. Fenton replied to Dave on 10 May 2004

First off, it's simply not possible to us GUIDs as primary key in an
Access application. Access simply can't handle them.

I've never used anything but Random Autonumbers as PKs in replicated
databases, and never once had a conflict from them.

I think using GUIDs is a fundamental error to begin with.

Why did you choose GUIDs? Yes, the numeric space is much larger than
with Long Integers, but on a practical basis, it's not enough to
make a difference.

Archived message: Replication conflicts (Microsoft Access Database)