Re: A philosophical newbie issue: catch redundant errors via relationships or programmically?

From: Tony Toews [MVP] <>
Date: Mon, 31 Dec 2007 19:13:09 GMT
Message-ID: <>

"David Cressey" <> wrote:

>Thanks. I could not get the compound key to work in Access, which is
>a bit strange (the restriction on whether a foreign key is a duplicate
>or is unique is rather hidden). After many permutations, I gave up,
>but it could be a peculiarity of Access.
>I could be wrong, but I don't think Access has any particular limitations in
>this regard.

I did an Access database using compound keys back in A2.0 in about 1995 or so. If anything it works a bit better these days.


Tony Toews, Microsoft Access MVP
   Please respond only in the newsgroups so that others can 
read the entire thread of messages.
   Microsoft Access Links, Hints, Tips & Accounting Systems at
   Tony's Microsoft Access Blog -
Received on Mon Dec 31 2007 - 20:13:09 CET

Original text of this message