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

...have you checked the data for nulls vs zero length strings?
William Hindman
----- Original Message ----- 
From: "Robert L. Stewart" <rl_stewart at highstream.net>
To: <accessd at databaseadvisors.com>
Sent: Thursday, March 22, 2007 2:08 PM
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
>