[AccessD] Manual Database Synchronisation

Hi Joshua

A note: You may use a GUID as autonumber.
We had some discussion on GUIDs in December - look up the archive.

/gustav


> In the meantime, my main concern with setting this up is how I
> handle the primary keys for records. Up until now, I have been a
> firm believer in using an autonumber for a primary key. Of course,
> this will not be possible in this scenario. When a record is added
> to the system and sent to all the other offices, the primary keys
> will have to match, so that my code will be able to match up the
> updated records when imported at the other end. The best idea I have
> come up with is to use a random autonumber, and attach a time-stamp
> to the end of that, and use it as a primary key. For there to be a
> conflict, it would mean that two offices have generated a duplicate
> random autonumber at the exact same second. I'm quite happy with the
> odds of that never happening.