[AccessD] Access and SQL Server

Gustav Brock Gustav at cactus.dk
Fri Mar 4 08:10:08 CST 2011


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






More information about the AccessD mailing list