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