[AccessD] "Faked" replication

I have never heard that they can't be used as PKs.  And they are just
strings so they should be able to be compared as well.  I would agree with
Gustav, a GIUD would be much simpler (and more efficient) than all of those
fields.

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steven W.
Erbach
Sent: Thursday, December 18, 2003 8:56 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] "Faked" replication


Gustav,

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

Regards,

Steve Erbach
Scientific Marketing
Neenah, WI
920-969-0504

Message created with Bloomba

Disclaimer: No tree was killed in the transmission of this message. However,
several coulombs of electrons were temporarily inconvenienced.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com