[AccessD] Access and SQL Server

Hi Gustav --

I meant Alternative (Natural) Keys Collisions with PKs ((Random) Autonumbers
or GUIDs) having different values.

Thank you.

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 4 ????? 2011 ?. 17:10
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Access and SQL Server

Hi Shamil et al

This is where GUIDs come in.

/gustav


>>> shamil at smsconsulting.spb.ru 04-03-2011 11:05 >>>
Hi Stuart --

<<<
I've never had a problem with an autonumber
>>>
"There is no free cheese in this world" you know :)

- replication could create subtle collision issues when autonumbers used -
and that would be another kind of collision from the one which could "arise
its ugly head" when natural PKs are used;
- memory overhead is another issue as Jim noted ("consistent data modelers"
do neglect it);
- ...

Isn't it time now to recapitulate constructively this discussion and to list
pedantically pros and cons of every approach? Anybody?

Thank you.

--
Shamil