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

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Thu Mar 22 14:20:27 CDT 2007


Have you tried speaking sternly to it?  If that doesn't work, I'd check to
be sure that the indexes don't allow duplicates.

Rocky
 




 	
	

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

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: 3/21/2007
7:52 AM
 




More information about the AccessD mailing list