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