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

Does the data have extra spaces?

Jay with 3 spaces after it won't be the same as Jay with no spaces...
 

-----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:09 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