Re: Do all tables have to have a primary key?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You're teaching good habits (although you'll get a very heated debate as to
whether you should always use autonumbers, or a natural key)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"maura" <maura@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:410DACD6-8095-4E45-B095-53C3699F2C59@xxxxxxxxxxxxxxxx
I have a few people in my office that are building a new database. A few of
the tables they do not have a primary key set. These tables are very minor
and they will be used as look-up tables, but I thought every table should
have a primary key, no matter how minor the table. What are your
thoughts...

I usually set an autonumber on the tables like this as a primary key. Am I
teaching good habits or just going overboard? Thanks, m.


.

Relevant Pages

  • 3-day novice, How do I calculate age in days? [C++]
    ... This is the 3rd day into teaching myself C++. ... broken links, read the 3 FAQs recommended, and have some books ordered. ... bad habits so I want them corrected now before they really become a habit. ... // Proggy the conversing program ...
    (alt.comp.lang.learn.c-cpp)
  • Re: Learning other styles without teacher?
    ... teaching myself at home on my electric? ... I don't think there is such a thing as bad habits, just the style you play ... lot of your classical playing could transfer to rock. ...
    (alt.guitar)
  • Re: Progress - should I continue?
    ... Thanks for all the responses. ... The track I was talking about was really making sure I wasn't teaching myself any bad habits early on in terms of technique. ... I know a few songs and yes, that is definitely the most fun way to practise. ...
    (alt.guitar.beginner)
  • Re: I finally got her to sit still
    ... Looks are deceiving the others are already teaching her their bad habits ... little devils ...
    (rec.pets.cats.anecdotes)