[AccessD] Unique index... NOT!!!

Charlotte Foust cfoust at infostatsystems.com
Thu Mar 22 14:32:00 CDT 2007


If Those fields are Null, the fields will be ignored because Null
doesn't match anything, and you will be allowed to enter "duplicates".
This phenomenon has been in Access as long as I recall.

Charlotte Foust  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert L.
Stewart
Sent: Thursday, March 22, 2007 11:08 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Unique index... NOT!!!

     Access 2003
     tblName
     NameID FName MName LName   Suffix
     1      Jay    Ray  Johnson   Jr
     2      Jay         Johnson
     5      Jay         Johnson
     Name ID is the primary key.
     There is a unique index on FName, MName, LName, and Suffix.
     Why is it allowing the entry of Name ID # 5?
     It is not enforcing the unique index. 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list