View Single Post
  #10  
Old July 24th, 2006, 02:30 PM posted to microsoft.public.access.tablesdbdesign
Craig Alexander Morrison
external usenet poster
 
Posts: 88
Default Hostel Database Setup

It is not largely irrelevant, Jet should (and does) implement these keys
via
indexes.


I will retract this slightly (remove "should") :- Jet and most if not all
other vendors have chosen to implement primary keys via indices (some refer
to this as an accident).

Any discussion on any other physical implementation is largely theoretical.
This is not the place for that.

The fact that for the last 15 years of development I have slipped into Keys
are Indexes is a compromise one has to make to make a living delivering
solutions with the products available.

Hell I even use SQL and that is something I hoped would have been replaced
by something Relational.

--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited