Board index Office Access

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

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/

 
 
 
Top

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

1. Index or Primary Key Cannot Contain a Null Value

2. Index or primary key cannot contain a null value.

3. Index or primary key cannot contain a Null Value

4. Index or primary key cannot contain a Null value

5. Index or primary key cannot contain a Null value (Error 3058)

6. What is meant by "Index or primary key cannot contain a Null value

7. Index or primary key cannot contain null values

8. Index or Primary Key Cannot Contain Null Value

9. Index or Primary key cannot contain null value

10. Error Message "Index or Primary Key cannot contain a null value"

11. Primary Key Contain a Null Value

12. Use of List box and 'Index or primary key cannot contain null"

13. Help: Error - Index or primary key can not contain Null value.

14. Index or Primary Key Cannot Have A Null Value

15. Index orPrimary key cannot contain a null value error #3058

All times are UTC
Board index