View Single Post
  #30  
Old December 5th, 2007, 10:57 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Data Primary key vs. Artificial (Autonumber) primary key

I'm from Chicago, we don't know what fault lines are. Could you use a
tornado analogy so that I can understand?

:-)


Fred


"John W. Vinson" wrote:

On Wed, 5 Dec 2007 05:18:01 -0800, Fred
wrote:

And that means at least occasionally correcting or
changing it.


well... there *is* Cascade Updates to cover that possibility.

But I agree, it's ideal if the primary key is rock solid stable. If it's only
San Andreas faultline rock solid stable, you need to depend on cascade
updates, which do work but have their own problems!

John W. Vinson [MVP]