>Yes I was thinking that some sort of transaction log that is maintained on all online units and some sort of update/reconciliation process when a unit comes back online.
>
>Updates to the transaction log would have to be sent to all online workstations.
>
>The case that is hard to adjust for is when the units with the most current copies of the transaction log are not online when the units that need the updates come online.

How about this: Each machine maintains a list of all of it's transactions (local). It also maintains a list of all the other machine ID's that have contacted it, and last update time/date and a list of all of it's replication partners and when it received it's last update from them. At some fixed interval each machine contacts all of the partners in it's replication list and sends it it's machine ID. That machine looks up the ID, finds out the last update that was sent and then synchronizes the data. Each record in the transaction journal contains a date/time stamp so if the process is interrupted you reset the last updated time/date stamp. The receiving station will either have to roll back the changes, or make note of the changes made so that when it reconnects at some later point it doesn't try to apply the same changes it's received.

Hopefully all this makes sense :)