Primary key cannot contain a null value.

Primary key cannot contain a null value.

Post by Chri » Fri, 08 Oct 2004 03:11:54


When copying one field in a database to another field, I
get the error "Primary key cannot contain a null value."
I currently have it set to "Yes, not allow duplicates." I
couldn't find the solution on the MS Knowledge base.
 
 
 

Primary key cannot contain a null value.

Post by Roger Carl » Fri, 08 Oct 2004 03:26:31

By definition, a primary key cannot contain a Null. There is no solution.
You either have to provide a value or remove the primary key designation
from the field.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://www.yqcomputer.com/

 
 
 

Primary key cannot contain a null value.

Post by Michael J. » Fri, 08 Oct 2004 03:34:01

In design view, select the field that is designated primary key and click
the Key icon (clear its primary key status).


--
---------------------------------------------------------------
Michael J. Strickland
Quality Services XXXX@XXXXX.COM
703-560-7380
---------------------------------------------------------------