[AccessD] "Faked" replication

Hi Steven

>>> 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.

As they are supposed to be absolutely (globally) unique you should be
able to use GUIDs as a primary key like (locally unique) Autonumbers.
That is a key feature of GUIDs.

If so, why should you "compare" them? A GUID would never be equal,
neither "larger" or "smaller" than another GUID, just different.

However, if you'll have to transport GUIDs outside the Access
environment, you may get into troubles of conversion although a string
representation is always possible. Are you familiar with the functions
GUIDFromString() and StringFromGUID()?

Also, look up the archive on GUID from Dec. 2002 and Feb./Apr./May 2003.

/gustav