replication in 2000 update/update error

[sloth]

Hey guys, i really need some help with replication, everywhere i search it is very brief in help.

Everything works except when I want to do a stock transfer (its a POS system, with databases in 3 shops, the warehouse and the managers computer)

As the shop is making sales, i cant let the manager transfer stock at the same time, as at that night i get update/update conflict (for the same stock record as it is editing that particular stock record corresponding to someone elses store id - every DB has their own store id).

Now ive tried timing the replication (its all done in VB for control)
and even written code to manually update the stock level in the managers DB but cant seem to pinpoint how to solve it

do i need to let all the replicas know that there is a change before i can change the record again by another replica?

Anyone with any experience in Office 2000 replication please come forward )


Thanks

 

[sloth]

anyone?

 

[MrP]

on knight in slightly dirty ex-shining armour steps forward and falls flat on his face

the only thing i can think of tis to make the priority of the one that the stock manager user higher than the rest.

as i remember (feel free to correct me) you can set the priority of replicas, so if for sakes of argument you have a normal replica for the sales people (set the prioity to 3 say) and then the stock manager has a replica with a higher priority (say 2 in this case) from what i understand, whatever he puts in would over write what the sales people put in.

either that or write some code that runs before the repication that corrrects the numbers before hand.

hope thats of some help, if not, feel free to ignore me

toodles