[AccessD] "Faked" replication

Hi Susan

> Microsoft recommends that you not use GUID's as primary keys, but I'm not
> sure that really means anything. :)

> http://www.devx.com/dbzone/Article/10167/0

Ehh, Susan ... aren't you (re)reading your own articles too fast:

<quote>

Microsoft discourages the use of GUID as a primary key, but that's
because most people don't really need universal uniqueness. When
uniqueness across many systems is vital, however, the GUID datatype is
definitely the way to go. Just remember that you pay a price in
performance.

</quote>

Isn't "across many systems" exactly the situation of Steve?

/gustav

PS: Nice picture of you and your mother!


>> >> You could choose to use GUIDs for autonumbers ... <<
>>
>> Thanks for your reply. My understanding is that they cannot be compared
> and that they shouldn't be used as primary keys. If I can't use them as
> primary keys then I'm back to the Corporation / Division / Location /
> Department / JobPosition multi-part key idea.