Re: Rule when primary key is needed?

From: Craig Alexander Morrison (reply_at_newsgroups.com)
Date: 08/15/04 

Date: Sun, 15 Aug 2004 16:06:20 +0100

The Access 2002 Knowledge Base article 283878 is, of course, available
online at www.microsoft.com also. 

--
Slainte
Craig Alexander Morrison
"Roland Bengtsson" <roland.bengtssonsf@home.se> wrote in message
news:49ceb5c5.0408150515.11d5e202@posting.google.com...
> Is there a rule when primary key is needed in a table?
> For example I have small tables with 5 - 20 posts. These are used with
> Comboboxes in another table. I realize now that a key isn't needed in
> the small tables.
>
> /Roland

Relevant Pages

  • Re: Updates vs. Inserts when Exporting Excel files into Access
    ... If the ID field is her primary key, ... So if the excel file ... My client wants a data dump of her online database to download and import ...
    (microsoft.public.access.externaldata)
  • Re: Rule when primary key is needed?
    ... Doug Steele, Microsoft Access MVP ... "Craig Alexander Morrison" wrote in message ... > The Access 2002 Knowledge Base article 283878 is, of course, available ... >> Is there a rule when primary key is needed in a table? ...
    (microsoft.public.access.gettingstarted)
  • Re: Circular reference?
    ... I also have wondered about this sort of thing. ... is the primary key from each instance of the Subjects table linked ... Craig Alexander Morrison ... Crawbridge Data Limited ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Multiple Primary Keys
    ... You can only enforce RI at engine level using the Primary Key. ... Craig Alexander Morrison ... > Shoot, here's what I forgot to explain. ...
    (microsoft.public.access.tablesdbdesign)
Loading